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 LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_categories p2c WHERE p.products_status = 1 AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = 1 AND p2c.categories_id = 41 ORDER BY pd.products_name LIMIT 40, 20
[TEP STOP]
2006 - MySQL server has gone away
INSERT INTO sessions (sesskey, expiry, value) VALUES ('g7pf8g2utn2me4req2p4miqktk', '1725870883', 'sessiontoken|s:32:\"d896353cef61370c201de2f0af9609b1\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:255:{s:8:\"3302____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8258____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6386____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8055____\";a:1:{s:3:\"qty\";i:1;}s:7:\"471____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8117____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3204____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8102____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8044____\";a:1:{s:3:\"qty\";i:1;}s:6:\"82____\";a:1:{s:3:\"qty\";i:1;}s:7:\"727____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7587____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2057____\";a:1:{s:3:\"qty\";i:1;}s:7:\"564____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6633____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8118____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6532____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6968____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8085____\";a:1:{s:3:\"qty\";i:1;}s:7:\"693____\";a:1:{s:3:\"qty\";i:1;}s:7:\"725____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4834____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8233____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8098____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1366____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7549____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6632____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7579____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6550____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6534____\";a:1:{s:3:\"qty\";i:1;}s:7:\"613____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6533____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4025____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4122____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8232____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7260____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8126____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3167____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3893____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1105____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2201____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8124____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2750____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8125____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8121____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8042____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2401____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3171____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8241____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8087____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6741____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1980____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2090____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6553____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2225____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4893____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7580____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5050____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8128____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2565____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8115____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8075____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7578____\";a:1:{s:3:\"qty\";i:1;}s:6:\"71____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5474____\";a:1:{s:3:\"qty\";i:1;}s:7:\"746____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6547____\";a:1:{s:3:\"qty\";i:1;}s:7:\"705____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7271____\";a:1:{s:3:\"qty\";i:1;}s:7:\"567____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7545____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8144____\";a:1:{s:3:\"qty\";i:1;}s:7:\"606____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6549____\";a:1:{s:3:\"qty\";i:1;}s:6:\"55____\";a:1:{s:3:\"qty\";i:1;}s:6:\"70____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3477____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5061____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8236____\";a:1:{s:3:\"qty\";i:1;}s:7:\"426____\";a:1:{s:3:\"qty\";i:1;}s:7:\"411____\";a:1:{s:3:\"qty\";i:1;}s:7:\"430____\";a:1:{s:3:\"qty\";i:1;}s:7:\"483____\";a:1:{s:3:\"qty\";i:1;}s:7:\"431____\";a:1:{s:3:\"qty\";i:1;}s:7:\"415____\";a:1:{s:3:\"qty\";i:1;}s:7:\"454____\";a:1:{s:3:\"qty\";i:1;}s:6:\"78____\";a:1:{s:3:\"qty\";i:1;}s:7:\"418____\";a:1:{s:3:\"qty\";i:1;}s:7:\"443____\";a:1:{s:3:\"qty\";i:1;}s:7:\"421____\";a:1:{s:3:\"qty\";i:1;}s:7:\"419____\";a:1:{s:3:\"qty\";i:1;}s:7:\"456____\";a:1:{s:3:\"qty\";i:1;}s:7:\"441____\";a:1:{s:3:\"qty\";i:1;}s:7:\"435____\";a:1:{s:3:\"qty\";i:1;}s:7:\"518____\";a:1:{s:3:\"qty\";i:1;}s:7:\"444____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8048____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7276____\";a:1:{s:3:\"qty\";i:1;}s:7:\"788____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7275____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5052____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3365____\";a:1:{s:3:\"qty\";i:1;}s:7:\"533____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7272____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2458____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6339____\";a:1:{s:3:\"qty\";i:1;}s:7:\"583____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2742____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8251____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8149____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5204____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8249____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8220____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4348____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6551____\";a:1:{s:3:\"qty\";i:1;}s:6:\"14____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1343____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6881____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3348____\";a:1:{s:3:\"qty\";i:1;}s:7:\"537____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8255____\";a:1:{s:3:\"qty\";i:1;}s:7:\"768____\";a:1:{s:3:\"qty\";i:1;}s:7:\"683____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8256____\";a:1:{s:3:\"qty\";i:1;}s:7:\"836____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8057____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6627____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6522____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2058____\";a:1:{s:3:\"qty\";i:1;}s:7:\"958____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8039____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7592____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5263____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2130____\";a:1:{s:3:\"qty\";i:1;}s:7:\"581____\";a:1:{s:3:\"qty\";i:1;}s:7:\"704____\";a:1:{s:3:\"qty\";i:1;}s:7:\"641____\";a:1:{s:3:\"qty\";i:1;}s:5:\"1____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3350____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5040____\";a:1:{s:3:\"qty\";i:1;}s:7:\"877____\";a:1:{s:3:\"qty\";i:1;}s:7:\"882____\";a:1:{s:3:\"qty\";i:1;}s:7:\"880____\";a:1:{s:3:\"qty\";i:1;}s:7:\"881____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1525____\";a:1:{s:3:\"qty\";i:1;}s:7:\"873____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6157____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7357____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7263____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7995____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1594____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8244____\";a:1:{s:3:\"qty\";i:1;}s:7:\"870____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6387____\";a:1:{s:3:\"qty\";i:1;}s:7:\"865____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1816____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6623____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3163____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4871____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3300____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3140____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3518____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1031____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5888____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2755____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2162____\";a:1:{s:3:\"qty\";i:1;}s:7:\"782____\";a:1:{s:3:\"qty\";i:1;}s:6:\"60____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5604____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5607____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5597____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2380____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7396____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2509____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5614____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5602____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2620____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3364____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2464____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6525____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2455____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8074____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1049____\";a:1:{s:3:\"qty\";i:1;}s:7:\"706____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4888____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4815____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4149____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1100____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1847____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2351____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5581____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6432____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4844____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7347____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1189____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6596____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8257____\";a:1:{s:3:\"qty\";i:1;}s:7:\"611____\";a:1:{s:3:\"qty\";i:1;}s:7:\"133____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1079____\";a:1:{s:3:\"qty\";i:1;}s:6:\"18____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5621____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8132____\";a:1:{s:3:\"qty\";i:1;}s:7:\"999____\";a:1:{s:3:\"qty\";i:1;}s:7:\"138____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5595____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1780____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1074____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2044____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6376____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1365____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8046____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7518____\";a:1:{s:3:\"qty\";i:1;}s:6:\"64____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2141____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6527____\";a:1:{s:3:\"qty\";i:1;}s:5:\"6____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1050____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3610____\";a:1:{s:3:\"qty\";i:1;}s:5:\"2____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8138____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2112____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6966____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1241____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1353____\";a:1:{s:3:\"qty\";i:1;}s:7:\"539____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7352____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2291____\";a:1:{s:3:\"qty\";i:1;}s:7:\"217____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1475____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2092____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5592____\";a:1:{s:3:\"qty\";i:1;}s:7:\"114____\";a:1:{s:3:\"qty\";i:1;}s:6:\"61____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4581____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8122____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6146____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2499____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7725____\";a:1:{s:3:\"qty\";i:1;}s:7:\"864____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1030____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2306____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8248____\";a:1:{s:3:\"qty\";i:1;}s:7:\"806____\";a:1:{s:3:\"qty\";i:1;}s:7:\"998____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1033____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2412____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6347____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2751____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3525____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8231____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4317____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2647____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5081____\";a:1:{s:3:\"qty\";i:1;}s:7:\"490____\";a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:23363.50000000001;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"01611\";s:12:\"content_type\";s:8:\"physical\";}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"CAD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:4:{s:5:\"cPath\";s:4:\"2_41\";s:4:\"ceid\";s:26:\"g7pf8g2utn2me4req2p4miqktk\";s:4:\"sort\";s:2:\"1a\";s:4:\"page\";s:1:\"3\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:4:{s:4:\"page\";s:37:\"ext/modules/content/reviews/write.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:3:\"955\";s:4:\"ceid\";s:26:\"g7pf8g2utn2me4req2p4miqktk\";}s:4:\"post\";a:0:{}}}new_products_id_in_cart|i:490;payment|s:14:\"paypal_express\";sendto|a:15:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";s:4:\"name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:14:\"street_address\";s:0:\"\";s:6:\"suburb\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:4:\"city\";s:0:\"\";s:7:\"zone_id\";s:2:\"74\";s:9:\"zone_name\";s:7:\"Ontario\";s:10:\"country_id\";s:2:\"38\";s:12:\"country_name\";N;s:18:\"country_iso_code_2\";N;s:18:\"country_iso_code_3\";N;s:17:\"address_format_id\";N;}billto|a:15:{s:9:\"firstname\";s:0:\"\";s:8:\"lastname\";s:0:\"\";s:4:\"name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:14:\"street_address\";s:0:\"\";s:6:\"suburb\";s:0:\"\";s:8:\"postcode\";s:0:\"\";s:4:\"city\";s:0:\"\";s:7:\"zone_id\";s:2:\"74\";s:9:\"zone_name\";s:7:\"Ontario\";s:10:\"country_id\";s:2:\"38\";s:12:\"country_name\";N;s:18:\"country_iso_code_2\";N;s:18:\"country_iso_code_3\";N;s:17:\"address_format_id\";N;}cartID|s:5:\"58485\";shipping|a:3:{s:2:\"id\";s:9:\"flat_flat\";s:5:\"title\";s:9:\"Flat Rate\";s:4:\"cost\";s:4:\"3.27\";}appPayPalEcSecret|s:16:\"6424581197684426\";') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)
[TEP STOP]