SELECT pd.*, p.*, 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 base_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special, IF(s.status, s.expires_date, NULL) AS special_expiration, IF(COALESCE(a.attribute_count, 0) > 0, 1, 0) AS has_attributes FROM products_description pd INNER JOIN products p ON pd.products_id = p.products_id LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN (SELECT products_id, COUNT(*) AS attribute_count FROM products_attributes GROUP BY products_id) a ON p.products_id = a.products_id WHERE p.products_id = 2030 AND pd.language_id = 1 AND p.products_status = 1
[TEP STOP]
1226 - User 'trophy_hpuno7' has exceeded the 'max_questions' resource (current value: 1)
INSERT INTO sessions (sesskey, expiry, value) VALUES ('ffc754d509c2e95ccc18c019bc227f5e', '1715370032', 'sessiontoken|s:32:\"796a13535cd67c95cf6211eac4440f1c\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:9:{i:799;a:1:{s:3:\"qty\";i:1;}i:1464;a:1:{s:3:\"qty\";i:1;}i:3067;a:1:{s:3:\"qty\";i:1;}i:3550;a:1:{s:3:\"qty\";i:1;}i:3700;a:1:{s:3:\"qty\";i:1;}i:1720;a:1:{s:3:\"qty\";i:1;}i:3559;a:1:{s:3:\"qty\";i:1;}i:3339;a:1:{s:3:\"qty\";i:1;}i:1845;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:429.99999999999994315658113919198513031005859375;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"30999\";s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"EUR\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:3:{s:4:\"page\";s:9:\"index.php\";s:3:\"get\";a:2:{s:5:\"cPath\";s:7:\"191_397\";s:4:\"ceid\";s:32:\"ffc754d509c2e95ccc18c019bc227f5e\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:3:{s:4:\"page\";s:16:\"address_book.php\";s:3:\"get\";a:1:{s:4:\"ceid\";s:32:\"ffc754d509c2e95ccc18c019bc227f5e\";}s:4:\"post\";a:0:{}}}new_products_id_in_cart|i:1845;') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]