Displaying 1 to 46 (of 46 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 = 7512 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 ('33c783a9f0835925539dee828a76710e', '1727791884', 'sessiontoken|s:32:\"913a97bef15b69cd4a6830bf946fa557\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:17:{i:17874;a:1:{s:3:\"qty\";i:1;}i:17877;a:1:{s:3:\"qty\";i:1;}i:17894;a:1:{s:3:\"qty\";i:1;}i:17898;a:1:{s:3:\"qty\";i:1;}i:17881;a:1:{s:3:\"qty\";i:1;}i:17856;a:1:{s:3:\"qty\";i:1;}i:17865;a:1:{s:3:\"qty\";i:1;}i:17901;a:1:{s:3:\"qty\";i:1;}i:17860;a:1:{s:3:\"qty\";i:1;}i:17888;a:1:{s:3:\"qty\";i:1;}i:17862;a:1:{s:3:\"qty\";i:1;}i:17875;a:1:{s:3:\"qty\";i:1;}i:17887;a:1:{s:3:\"qty\";i:1;}i:17903;a:1:{s:3:\"qty\";i:1;}i:17876;a:1:{s:3:\"qty\";i:1;}i:17857;a:1:{s:3:\"qty\";i:1;}i:17873;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:0;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"51080\";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:2:{s:4:\"ceid\";s:32:\"33c783a9f0835925539dee828a76710e\";s:11:\"products_id\";s:5:\"17902\";}s:4:\"post\";a:0:{}}i:1;a:3:{s:4:\"page\";s:9:\"index.php\";s:3:\"get\";a:2:{s:4:\"ceid\";s:32:\"33c783a9f0835925539dee828a76710e\";s:16:\"manufacturers_id\";s:2:\"48\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:3:{s:4:\"page\";s:37:\"ext/modules/content/reviews/write.php\";s:3:\"get\";a:2:{s:4:\"ceid\";s:32:\"33c783a9f0835925539dee828a76710e\";s:11:\"products_id\";s:4:\"5811\";}s:4:\"post\";a:0:{}}}new_products_id_in_cart|i:17873;') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]