(SELECT `related`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223`
FROM `merch`, `sku-us-usd` as sku, `option-us` as opt JOIN `product-us` as pdt
ON opt.product = pdt.product
WHERE opt.`option` = `merch`.`related` AND sku.option = merch.related AND sku.stock >= '1' AND `merch`.`option` =
(SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1)
GROUP BY `related` limit 3)
UNION DISTINCT
(SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223`
FROM `sku-us-usd` as sku, `option-status`,`option-us` as opt JOIN `product-us` as pdt
ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option`
WHERE sku.`option` = opt.`option`
AND `option-status`.`option` = opt.`option`
AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1) LIMIT 1)
AND `option-status`.`us-usd-online` = (SELECT `us-usd-online` FROM `option-status` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1) LIMIT 1)
AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6)
UNION DISTINCT
(SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223`
FROM `sku-us-usd` as sku, `option-status`,`option-us` as opt JOIN `product-us` as pdt
ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option`
WHERE sku.`option` = opt.`option`
AND `option-status`.`option` = opt.`option`
AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1) LIMIT 1)
AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` = '/tall/jeans/36inch/richmond-straight-cut-jeans/purple haze' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6)
LIMIT 3
Array
(
[scheme] => http
[host] => us.longtallsally.com
[path] => /tall/jeans/36inch/richmond-straight-cut-jeans/purple haze
[query] => category=f-034_jeans
)
You may also like...
Short Sleeve Satin Trim Scoop Neck Top
US $35
Silver Natsuki Capri
US $85 US $49
Silver Suki Surplus Capri
US $85 US $59