select 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.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 h2f_products_description pd, h2f_products p left join h2f_manufacturers m on p.manufacturers_id = m.manufacturers_id left join h2f_specials s on p.products_id = s.products_id, h2f_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 = '101' order by pd.products_name limit 0, 50 [TEP STOP] 1226 - User 'leshoppijfauth' has exceeded the 'max_questions' resource (current value: 64000) INSERT INTO `h2f_usu_cache` (cache_name, cache_data, cache_date) VALUES ('a55c116a526f35cdb7072fd174bed3f3', 'pZfNTttAEMdfZeUDvXrtfJpTgUIrQRsR1Cta7E2yqvG6u3bUqsqlT1L11FR9C79Jn6Qz9poEmBQTToRk/NvZmf98WERB9M1G/ciLJ6JYeIci6o3wm0Hk8eE19zl+1drk78Wt9A5txEeRd7Wo1pbJgr3LZqVVOrP4C5Jaq3FjxJbSFN7hSkV8CDDeHvgUDB/gIfUEfD6tfheythmNKZNh5J0LFotlY8QD8mT4502uYmmUZFORVuvGekBbD7aty9i05rxHmoMLE5EpaSw706W5FVnS3GpE2gP9Qiirs4bpD8nA09AHJ/cApVVmWSJZ4P/9/schR/sjwaiFseoHC7eo45dSw5ba31C5/1Jqv6UOt6h8f2oIRmlZx3RDDGk3KV3dxwU88l7n1dpoVP2VMIXKxE0qG4UM+i/AXkljVCYtO2CnWsHfMyMa7JhO1dNYNHlbKnCPJa90qpbOTx4GLyAeKRuXqrDMoklL7O1JhPq5MuVs1tTkmNb60xhoWh8hFWpu3B3HdCF2uCKU4VSmmIeJVss73mB/zy50WQiTtKR9Q8W5M7FsaUTsAk9LmWx6jyI/VUbnLoN05DtwRhtJ1KQeLdcOpABCfyxmOFMO2LGIBVRZxnJdJsZ1+L2dhCwcL3SsU+G87NM9pYuXAbB0NlMWrdDVE2nhswOP6CbQAYwTdVL9LIAJ/a+om4s0zcVp9XWBov4U6hkaVu12Ubaa5gM6VZ3WhMDHMMxmRkIrSKp1rEvcGNxs3ZGpTmTuuw3kKBWZk7lPp2vPhcan+9+zaJlWxtHojHeLIgyxi2oNF51D2ht79BNUtXUA3TE6HQAS+aBTnc0dKtwfBa5eaq1utFOPT7eerlF8sDP6tMS7KQbHcgyN0ULM7sRN8bYXzEdt7BxSAFOkXWLJqO8GoKuXi/IWPZ3mykChyfJLs2+Qw2g3KsB2peNPhVD1IKqx0BNyqPBcGNcUOCeF9x8PqTCFpCJ2Q4bY7qtfm+ef6QTGWX2G0Bg3DkkVba3VjzeQE+w29YhIpHAhHpMlvROD+wL8YGWauvcRMkW73cAw6HLeDICJMLPy1t2H7FQ7QTiFxbKpglWTotzopIwLe60Sr3nlQDXXC3uIXNxp72yye5Kp2zEDzzK21F/FXLK524y9NnixKORc4+S6e/Z+g2wO2DJDNywc7dXvlavV6h8=', '2025-02-12 02:08:23') [TEP STOP] |
