1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') p left join eProductsExtra pe on p.product_id=pe.product_id order by p.product' at line 1

select * from (select p.* from eProducts p left join eProductsRelation pr on p.product_id=pr.child_id where p.product_visible='1' and cp_show=1 && pr.parent_id=) p left join eProductsExtra pe on p.product_id=pe.product_id order by p.product_order, p.product_id

[TEP STOP]