VSDH Fotografie

Insecten & Spinnen

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, 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, 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 = 16 AND p.status IN ('active','sold') GROUP BY p.id ORDER BY p.showorder ASC LIMIT 0, 60

Wij maken gebruik van cookies

Deze website gebruikt functionele cookies om uw voorkeuren op te slaan. Tevens gebruiken wij analytische cookies om bezoekersstatistieken te meten. Ook worden er cookies geplaatst door sociale media-netwerken. Meer informatie over cookies lees je in onze privacy verklaring: Privacy verklaring