SELECT sum(tax_rate) AS tax_rate FROM tax_rates tr LEFT JOIN zones_to_geo_zones za ON (tr.tax_zone_id = za.geo_zone_id) LEFT JOIN geo_zones tz ON (tz.geo_zone_id = tr.tax_zone_id) WHERE (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = 38) AND (za.zone_id is null or za.zone_id = '0' or za.zone_id = 74) AND tr.tax_class_id = 1 group by tr.tax_priority
[TEP STOP]
2006 - MySQL server has gone away
INSERT INTO sessions (sesskey, expiry, value) VALUES ('e4r224mh0dtah4ro6l30r6t28h', '1725847341', 'sessiontoken|s:32:\"49d6add379affb9edc7abdb208e3d5c6\";cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:48:{s:8:\"8053____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8048____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1546____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8057____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4348____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8256____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5886____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2224____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8093____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4371____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3109____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7995____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6383____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6692____\";a:1:{s:3:\"qty\";i:1;}s:7:\"594____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6533____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4216____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5105____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2091____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4204____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2272____\";a:1:{s:3:\"qty\";i:1;}s:7:\"555____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2207____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6553____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8111____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3073____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8062____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1142____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8241____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8056____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1034____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3004____\";a:1:{s:3:\"qty\";i:1;}s:8:\"2130____\";a:1:{s:3:\"qty\";i:1;}s:7:\"784____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6633____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6527____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5263____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1410____\";a:1:{s:3:\"qty\";i:1;}s:8:\"8261____\";a:1:{s:3:\"qty\";i:1;}s:8:\"3117____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1833____\";a:1:{s:3:\"qty\";i:1;}s:8:\"4210____\";a:1:{s:3:\"qty\";i:1;}s:8:\"6468____\";a:1:{s:3:\"qty\";i:1;}s:8:\"7580____\";a:1:{s:3:\"qty\";i:1;}s:8:\"1625____\";a:1:{s:3:\"qty\";i:1;}s:7:\"760____\";a:1:{s:3:\"qty\";i:1;}s:7:\"308____\";a:1:{s:3:\"qty\";i:1;}s:8:\"5050____\";a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";s:5:\"35708\";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:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:1:\"2\";s:4:\"ceid\";s:26:\"e4r224mh0dtah4ro6l30r6t28h\";}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:4:\"2269\";s:4:\"ceid\";s:26:\"e4r224mh0dtah4ro6l30r6t28h\";}s:4:\"post\";a:0:{}}}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|N;new_products_id_in_cart|i:5050;payment|s:14:\"paypal_express\";') ON DUPLICATE KEY UPDATE expiry = VALUES(expiry), value = VALUES(value)