VSDH Fotografie

Vlinders

Lees verder

SQL = SELECT p.id, p.status, p.label, p.title_L1, oneliner_L1, img_1, basic_unit, packsize, minqnty, vat_perc, date_offer, variantgroups, vargroup1_name_L1, vargroup2_name_L1, client_minlevel, graduatedlevels, gradlevel_1, gradlevel_2, gradlevel_3, gradlevel_4, gradlevel_5, gradlevel_6, gradlevel_7, gradlevel_1_disc, gradlevel_2_disc, gradlevel_3_disc, gradlevel_4_disc, gradlevel_5_disc, gradlevel_6_disc, gradlevel_7_disc, clientdiscounts_yn, client_1_disc, client_2_disc, client_3_disc, client_4_disc, client_1_minqnty, client_2_minqnty, client_3_minqnty, client_4_minqnty, showstock, stockwarning, deliverynostock_L1, deliveryinstock_L1, v.price_norm, v.price_sale, v.price_stup, v.stock, v.SKU, v.id AS var_id, c1.id AS cat1_id, c2.id AS cat2_id, c3.id AS cat3_id, c1.title_L1 AS cat1_title, c2.title_L1 AS cat2_title, c3.title_L1 AS cat3_title FROM products p LEFT JOIN product_variants v ON v.product_id = p.id LEFT JOIN categories c1 ON p.cat_id = c1.id LEFT JOIN categories c2 ON c1.parent_id = c2.id LEFT JOIN categories c3 ON c2.parent_id = c3.id WHERE v.showorder = 1 AND p.showon_D1 = 'Y' AND c1.showon_D1 = 'Y' AND p.cat_id = 15 AND p.status IN ('active','sold') AND (client_minlevel IS NULL OR client_minlevel <= 0) GROUP BY p.id ORDER BY p.showorder ASC LIMIT 0, 60