|
|||||||||||||||||
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 limit 0, 54 [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', 'vVXLbtswEPwVQociuUkUZcv0yUmKXOoH0iI9GguZUVlIpEpSQYrAH+Tv8I+VlMXUcgUlaN2cJNGcndnd2TXQmD5rmtAgW4H5FkyBRlF7gskaJ+4EtwfVAkoWTDUlKQ0+MY0qzpSyT8UyKbThpt7v7OfFDRQF5Ax9QHNQOSsKpi8dztH4GBGmwS2UJUNXUhspgumWU0ycAK/o3+i2mk7aJNYRToO+yFFyiJzJ+pEpwwXTDTD1QEx6cX+tqC3r6P+VNfRlveOPcMw5fg9OWXY403ewz73MQbBu26JRb9ti0iUWYGrVxEcXJ40a0SAaWd/g3gzeGqhLj1vUyw10XYDW/Efd2s6TxucknZySzoThm/1OQQXCtMxHk9LveFdvF2al5KbmxqEszO6KoHInmdFrvnHIhD5zSib2rdksUXx0Q/hMLGwm8oIhJoyyKtDV8vOX5QJZRW4Wq/3OT2cGhuVScfYb/efmONAcXXVSbOo2qaTZK4QM6sFhv57zioijYRGWyDmf+WJcg1L7HSLhEwnPXI5wuD2pV3K/vJ0tPqJ5XRiOHqQqwVizEf96+SZZfkAHZKWNrCQdlBWlp126W85nQxJO9tKAgHHrZzuBJYj6ATI3W8qbOnamxn4unJDurRfGsZVYFBxExtCK66z9R7Elfx1sZ/CG6e/yJ9RPB8O8jrE/fLX5KODKZbD9BQ==', '2026-06-06 21:00:30') [TEP STOP] | ||||||||||||
