SELECT p.product_id, p.store_id AS pstore_id, p.`name` AS pname, p.description, p.ord AS pord, p.sds, p.cas, p.z, p.url, p.label_type,
v.variation_picture, v.cart_picture, v.notes AS vnotes, v.var_id, v.`name` AS vname, v.price, v.sale_price, v.qty_disc, v.ord AS vord, v.store_id,
m.`name` AS mname,
t.type_id, t.ord AS tord, t.override_picture_size AS varpicsize, t.`name` AS tname,
d.datasheet_id
FROM store_prodvariations v
LEFT JOIN store_product p ON p.product_id=v.prod_id
LEFT JOIN store_manufacturer m ON m.manufacturer_id=p.manufacturer_id
LEFT JOIN store_type t ON t.type_id=p.type_id
LEFT JOIN datasheets d ON d.sheet_name=p.`name` OR (p.datasheet_abbr<>'' AND d.abbr=p.datasheet_abbr) WHERE t.`name` IS NOT NULL AND p.account_id=1 AND v.store_id=1 AND (v.price<>0 OR v.`name`='$call') AND NOT v.NFS
AND p.type_id IN (95) GROUP BY p.`name` LIMIT 0,150
Main Categories → Ribs & Scrapers