Displaying 1 to 2 (of 2 products)
SELECT p.*, pd.*, m.*, 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, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status = 1 AND pd.language_id = 1 AND p2c.categories_id = 11 ORDER BY pd.products_name LIMIT 0, 50
[TEP STOP]
2006 - MySQL server has gone away
INSERT INTO sessions (sesskey, expiry, value) VALUES ('22345f01d58815a32a8f074130f77b4c', '1727795219', 'sessiontoken|s:32:\"02f5ea19273b72a3278f75aecd2dcd35\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:32:{i:17856;a:1:{s:3:\"qty\";i:1;}i:17902;a:1:{s:3:\"qty\";i:2;}i:17886;a:1:{s:3:\"qty\";i:1;}i:17874;a:1:{s:3:\"qty\";i:1;}i:1975;a:1:{s:3:\"qty\";i:1;}i:17892;a:1:{s:3:\"qty\";i:1;}i:17869;a:1:{s:3:\"qty\";i:1;}i:17871;a:1:{s:3:\"qty\";i:1;}i:17889;a:1:{s:3:\"qty\";i:1;}i:17894;a:1:{s:3:\"qty\";i:1;}i:17867;a:1:{s:3:\"qty\";i:1;}i:17872;a:1:{s:3:\"qty\";i:1;}i:17855;a:1:{s:3:\"qty\";i:1;}i:17893;a:1:{s:3:\"qty\";i:1;}i:17884;a:1:{s:3:\"qty\";i:1;}i:17895;a:1:{s:3:\"qty\";i:1;}i:17888;a:1:{s:3:\"qty\";i:1;}i:17899;a:1:{s:3:\"qty\";i:1;}i:17876;a:1:{s:3:\"qty\";i:1;}i:17877;a:1:{s:3:\"qty\";i:1;}i:17883;a:1:{s:3:\"qty\";i:1;}i:17896;a:1:{s:3:\"qty\";i:1;}i:17901;a:1:{s:3:\"qty\";i:2;}i:17898;a:1:{s:3:\"qty\";i:1;}i:17865;a:1:{s:3:\"qty\";i:1;}i:17904;a:1:{s:3:\"qty\";i:1;}i:17879;a:1:{s:3:\"qty\";i:1;}i:17859;a:1:{s:3:\"qty\";i:1;}i:17878;a:1:{s:3:\"qty\";i:1;}i:17891;a:1:{s:3:\"qty\";i:1;}i:17900;a:1:{s:3:\"qty\";i:1;}i:17885;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:0;s:6:\"weight\";d:10;s:6:\"cartID\";s:5:\"20444\";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:\"products_new.php\";s:3:\"get\";a:3:{s:6:\"action\";s:7:\"buy_now\";s:4:\"ceid\";s:32:\"22345f01d58815a32a8f074130f77b4c\";s:11:\"products_id\";s:5:\"17885\";}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:5:\"10_11\";s:4:\"ceid\";s:32:\"22345f01d58815a32a8f074130f77b4c\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}new_products_id_in_cart|i:17902;') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]