SELECT pr.pid, pr.title, pr.description, pr.price, pr.filename, pr.shortdescription, pr.packagecontents, pr.productCode, pr.available, pm.pmid, so.offerprice FROM specialoffers AS so JOIN prod AS pr ON pr.pid=so.productid JOIN productmenu AS pm ON pm.productid=pr.pid WHERE pm.live=1 GROUP BY pr.pid ORDER BY pm.displayOrder
|