|
|||||||||||||||||
select p.products_order, p.products_image, pd.products_name, pd.products_name2, pd.products_description, pd.products_caracteristiques, p.products_date_available, p.adh_cart, p.group_products, p.products_affect, p.name, p.price, p.shipping_module, p.netWeight, p.status, p.products_id, p.code, pd.products_viewed, p.products_quantity_mini, p.products_quantity, p.manufacturers_id, p.products_price, p.products_remise, p.design_surface, p.products_price_surface, p.products_buy_text, p.products_master, p.products_master_status, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from new_cimb_products_description pd, new_cimb_products p left join new_cimb_manufacturers m on p.manufacturers_id = m.manufacturers_id left join new_cimb_specials s on p.products_id = s.products_id, new_cimb_products_to_categories p2c where p.products_status = '1' and p.products_quantity > 0 and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '25' order by p.products_order [TEP STOP] 1226 - User 'leshoppijfcust' has exceeded the 'max_questions' resource (current value: 40000) INSERT INTO `new_cimb_usu_cache` (cache_name, cache_data, cache_date) VALUES ('7182873bb36183d1375621509fe8750e', 'vVXLbtswEPwVQociuRQiJdkKfXKSIpf6AbdIj8ZCZlQWEumSVJAg8Af5O/xjJWUxkFxBCdokJ1EUZ2d2ObsCGtEnTRMaZEswP4MJUIybHRKvSeJ2SLOxnUPJgommcUqDr0yjLWdK2adimRTacFMd9vb17BqKAnKGPqEZqJwVBdPnDudofAxMaHADZcnQpdRGimCy45TEToBX9H90O00vmiTWmKRBX2ScHCNnsrpnynDBdA1MPZDEvbh/VtSUdfR+ZQ19WVf8Htqc44/glGWHM/0A+9zKHATrXhse9V5bFHeJBZhK1fHR2clFjWiAR9Y3pDeD1wbq0pMG9XwCXRWgNf9dNbbzpNFbkl6ckk6F4ZvDXsEWhGmYW53S73hXbxdmqeSm4sahLMzOimDrdjKj13zjkAl94jQhdlVPFhy1TggfzNKt4FEKhD8nISrR5eLb98Xcd2QGhuVScdZC/DUtjqFbRx29TdcmktSzJI4HNRBr2qnIC4aYMMpW4l1ERHhYhCVybmcNOboCpQ57FIcPcfjG5QgHlUSpV3K7uJnOv6BZVRiO7qQqwViDxX55/ipZvikHZKW1rCQddkp6ekurxWw6JOFkFg0IGDcetl1XgqjuIHP9pLyRI2dk4nvBCemeemYcW4lFwUFkDC25zpq/iC35y2DbCNdM/5KPUD0cDfMyxn74YfNRwJXLYPcH', '2026-06-11 13:59:34') [TEP STOP] | ||||||||||
