Displaying 1 to 50 (of 135 products)
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 = 5596 AND pd.language_id = 1 AND p.products_status = 1
[TEP STOP]
2006 - MySQL server has gone away
INSERT INTO sessions (sesskey, expiry, value) VALUES ('0c332cc6c6403f8607301043ed8dea5f', '1727795314', 'sessiontoken|s:32:\"4e0ba05c729f869ec033ce26904ce89d\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:39:{i:7199;a:1:{s:3:\"qty\";i:1;}i:1974;a:1:{s:3:\"qty\";i:1;}i:7206;a:1:{s:3:\"qty\";i:1;}i:7289;a:1:{s:3:\"qty\";i:1;}i:7430;a:1:{s:3:\"qty\";i:1;}i:7191;a:1:{s:3:\"qty\";i:1;}i:7434;a:1:{s:3:\"qty\";i:1;}i:7436;a:1:{s:3:\"qty\";i:1;}i:7423;a:1:{s:3:\"qty\";i:1;}i:1972;a:1:{s:3:\"qty\";i:1;}i:7324;a:1:{s:3:\"qty\";i:1;}i:7439;a:1:{s:3:\"qty\";i:1;}i:7435;a:1:{s:3:\"qty\";i:1;}i:7428;a:1:{s:3:\"qty\";i:1;}i:7316;a:1:{s:3:\"qty\";i:1;}i:7201;a:1:{s:3:\"qty\";i:1;}i:7200;a:1:{s:3:\"qty\";i:1;}i:7290;a:1:{s:3:\"qty\";i:1;}i:7429;a:1:{s:3:\"qty\";i:1;}i:7198;a:1:{s:3:\"qty\";i:1;}i:7438;a:1:{s:3:\"qty\";i:1;}i:7203;a:1:{s:3:\"qty\";i:1;}i:7195;a:1:{s:3:\"qty\";i:1;}i:7433;a:1:{s:3:\"qty\";i:1;}i:7202;a:1:{s:3:\"qty\";i:1;}i:7425;a:1:{s:3:\"qty\";i:1;}i:7437;a:1:{s:3:\"qty\";i:1;}i:7204;a:1:{s:3:\"qty\";i:1;}i:7315;a:1:{s:3:\"qty\";i:1;}i:7192;a:1:{s:3:\"qty\";i:1;}i:7213;a:1:{s:3:\"qty\";i:1;}i:7424;a:1:{s:3:\"qty\";i:1;}i:7210;a:1:{s:3:\"qty\";i:1;}i:7427;a:1:{s:3:\"qty\";i:1;}i:7196;a:1:{s:3:\"qty\";i:1;}i:8965;a:1:{s:3:\"qty\";i:1;}i:7205;a:1:{s:3:\"qty\";i:1;}i:8482;a:1:{s:3:\"qty\";i:1;}i:8481;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:0;s:6:\"weight\";d:1091.99;s:6:\"cartID\";s:5:\"78781\";s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:2:{i:0;a:3:{s:4:\"page\";s:16:\"product_info.php\";s:3:\"get\";a:3:{s:4:\"ceid\";s:32:\"0c332cc6c6403f8607301043ed8dea5f\";s:8:\"currency\";s:3:\"USD\";s:11:\"products_id\";s:4:\"7191\";}s:4:\"post\";a:0:{}}i:1;a:3:{s:4:\"page\";s:9:\"index.php\";s:3:\"get\";a:2:{s:5:\"cPath\";s:3:\"3_7\";s:4:\"ceid\";s:32:\"0c332cc6c6403f8607301043ed8dea5f\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:3:{s:4:\"page\";s:16:\"product_info.php\";s:3:\"get\";a:3:{s:6:\"action\";s:6:\"notify\";s:4:\"ceid\";s:32:\"0c332cc6c6403f8607301043ed8dea5f\";s:11:\"products_id\";s:4:\"7432\";}s:4:\"post\";a:0:{}}}new_products_id_in_cart|i:8481;') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]