Displaying 1 to 50 (of 194 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 = 16696 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 ('cc3845f48d61b41c50c2c3177877ddae', '1727795841', 'sessiontoken|s:32:\"6915a370576b708c6a2cef78eddf038d\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:34:{i:11156;a:1:{s:3:\"qty\";i:1;}i:11380;a:1:{s:3:\"qty\";i:1;}i:11145;a:1:{s:3:\"qty\";i:1;}i:11290;a:1:{s:3:\"qty\";i:1;}i:11114;a:1:{s:3:\"qty\";i:1;}i:11149;a:1:{s:3:\"qty\";i:1;}i:11174;a:1:{s:3:\"qty\";i:1;}i:11147;a:1:{s:3:\"qty\";i:1;}i:11120;a:1:{s:3:\"qty\";i:1;}i:11501;a:1:{s:3:\"qty\";i:1;}i:11096;a:1:{s:3:\"qty\";i:1;}i:11510;a:1:{s:3:\"qty\";i:1;}i:11379;a:1:{s:3:\"qty\";i:1;}i:9062;a:1:{s:3:\"qty\";i:1;}i:11487;a:1:{s:3:\"qty\";i:1;}i:11148;a:1:{s:3:\"qty\";i:1;}i:11293;a:1:{s:3:\"qty\";i:1;}i:11500;a:1:{s:3:\"qty\";i:1;}i:11159;a:1:{s:3:\"qty\";i:1;}i:11144;a:1:{s:3:\"qty\";i:1;}i:12144;a:1:{s:3:\"qty\";i:1;}i:11130;a:1:{s:3:\"qty\";i:1;}i:11121;a:1:{s:3:\"qty\";i:1;}i:11175;a:1:{s:3:\"qty\";i:1;}i:11172;a:1:{s:3:\"qty\";i:1;}i:11146;a:1:{s:3:\"qty\";i:1;}i:12146;a:1:{s:3:\"qty\";i:1;}i:11291;a:1:{s:3:\"qty\";i:1;}i:11090;a:1:{s:3:\"qty\";i:1;}i:11185;a:1:{s:3:\"qty\";i:1;}i:11502;a:1:{s:3:\"qty\";i:1;}i:11494;a:1:{s:3:\"qty\";i:1;}i:17904;a:1:{s:3:\"qty\";i:1;}i:17899;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:0;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"32542\";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:1:{i:0;a:3:{s:4:\"page\";s:9:\"index.php\";s:3:\"get\";a:2:{s:5:\"cPath\";s:11:\"180_220_313\";s:4:\"ceid\";s:32:\"cc3845f48d61b41c50c2c3177877ddae\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}new_products_id_in_cart|i:17899;') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]