SELECT product.* FROM `product` WHERE 1 AND status = 1 AND hide = 0 AND user_id = '5' AND type = 'product' AND sys = 0 AND (type_variant = 1 OR type_variant = 0) AND special_order = 0 AND NOT EXISTS(select * from product_meta pmta where pmta.identifier=product.id and pmta.field='trade_account' and pmta.value='1') GROUP BY product.id ORDER BY feature DESC, CASE WHEN price_special>0 OR special=1 OR EXISTS (SELECT * FROM product_special ps INNER JOIN product_special_item psi ON ps.id=psi.product_special_id WHERE ps.status=1 AND psi.product_id=product.id AND ps.date_from <= 1734781947 AND ps.date_to > 1734781947) OR EXISTS (SELECT * FROM product p2 WHERE p2.parent_id=product.id AND p2.hide=0 AND p2.status=1 AND p2.type='product' AND p2.type_variant=2 AND EXISTS(SELECT * FROM product_special ps INNER JOIN product_special_item psi ON ps.id=psi.product_special_id WHERE psi.product_id=p2.id AND ps.status=1 AND ps.date_from <= 1734781947 AND ps.date_to > 1734781947)) THEN 1 ELSE 0 END DESC, sort ASC LIMIT 0,24
Shop Online - Trailer Parts, Offroad Suspensions & Vehicle Lighting AU
