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
Cheap - Quality Furniture, Bedroom Furniture, Oak Furniture, Pine Furniture, Somerset
Details
