INSERT IGNORE INTO `orders`(`last4`,`receipt_number`,`receipt_url`,`is_receipt`,`order_id`, `parent_id`, `status`, `currency`,`version`,`prices_include_tax`,`date_created`,`date_modified`, `discount_total`, `discount_tax`, `shipping_total`,`shipping_tax`,`cart_tax`,`total`,`total_tax`, `customer_id`, `order_key`, `billing`,`shipping`,`payment_method`,`payment_method_title`,`transaction_id`, `customer_ip_address`, `customer_user_agent`, `created_via`,`customer_note`,`date_completed`,`date_paid`,`cart_hash`, `number`, `meta_data`, `line_items`,`tax_lines`,`shipping_lines`,`fee_lines`,`coupon_lines`, `refunds`, `date_created_gmt`, `date_modified_gmt`,`date_completed_gmt`,`date_paid_gmt`,`currency_symbol`,`links`,`shipping_method_type`,`square_order_id`,`square_invoice_id`,`order_from`,`email`) VALUES ('3229','ti0B','https://squareup.com/receipt/preview/ti0BHnXfstuiIFQh2qDicvu3uaB','1','rXLkSJHLTkO8daVreRDl1EfeV','0','on-hold','USD','5.9.0','','2022-09-06 02:32:43','2022-09-06 02:32:43','0.00','0.00','0','0.00','0.19','92.89','0.19','0','','O:8:\"stdClass\":11:{s:10:\"first_name\";s:5:\"Jason\";s:9:\"last_name\";s:8:\"Resendiz\";s:7:\"company\";N;s:9:\"address_1\";N;s:9:\"address_2\";s:0:\"\";s:4:\"city\";N;s:5:\"state\";N;s:8:\"postcode\";N;s:7:\"country\";s:2:\"US\";s:5:\"email\";N;s:5:\"phone\";N;}','O:8:\"stdClass\":11:{s:10:\"first_name\";s:5:\"Jason\";s:9:\"last_name\";s:8:\"Resendiz\";s:7:\"company\";N;s:9:\"address_1\";N;s:9:\"address_2\";s:0:\"\";s:4:\"city\";N;s:5:\"state\";N;s:8:\"postcode\";N;s:7:\"country\";s:2:\"US\";s:5:\"email\";N;s:5:\"phone\";N;}','','','0','167.114.221.140','Square Connect v2','','','2022-09-06 02:32:43','2022-09-06 02:32:43','','1','','a:1:{i:0;O:8:\"stdClass\":15:{s:2:\"id\";N;s:4:\"name\";s:29:\"Backfill/Spoils/Dump/Concrete\";s:10:\"product_id\";N;s:12:\"variation_id\";N;s:8:\"quantity\";s:4:\"3.00\";s:9:\"tax_class\";s:13:\"sale-tax-rate\";s:12:\"subtotal_tax\";i:0;s:8:\"subtotal\";i:90;s:5:\"total\";i:90;s:9:\"total_tax\";i:0;s:5:\"taxes\";O:8:\"stdClass\":3:{s:2:\"id\";i:2;s:5:\"total\";i:0;s:8:\"subtotal\";i:0;}s:9:\"meta_data\";a:0:{}s:3:\"sku\";s:0:\"\";s:5:\"price\";i:30;s:11:\"parent_name\";s:0:\"\";}}','a:1:{i:0;O:8:\"stdClass\":9:{s:2:\"id\";i:460;s:9:\"rate_code\";s:5:\"TAX-1\";s:7:\"rate_id\";i:2;s:5:\"label\";s:3:\"Tax\";s:8:\"compound\";s:0:\"\";s:9:\"tax_total\";d:0.19;s:18:\"shipping_tax_total\";s:4:\"0.00\";s:12:\"rate_percent\";s:0:\"\";s:9:\"meta_data\";s:0:\"\";}}','O:8:\"stdClass\":11:{s:10:\"first_name\";s:5:\"Jason\";s:9:\"last_name\";s:8:\"Resendiz\";s:7:\"company\";N;s:9:\"address_1\";N;s:9:\"address_2\";s:0:\"\";s:4:\"city\";N;s:5:\"state\";N;s:8:\"postcode\";N;s:7:\"country\";s:2:\"US\";s:5:\"email\";N;s:5:\"phone\";N;}','a:1:{i:0;O:8:\"stdClass\":9:{s:2:\"id\";i:458;s:4:\"name\";s:26:\"3% convenience fee applied\";s:9:\"tax_class\";s:1:\"0\";s:10:\"tax_status\";s:7:\"taxable\";s:6:\"amount\";d:2.89;s:5:\"total\";d:2.89;s:9:\"total_tax\";d:0;s:5:\"taxes\";a:0:{}s:9:\"meta_data\";a:1:{i:0;O:8:\"stdClass\":5:{s:2:\"id\";i:4202;s:3:\"key\";s:15:\"_last_added_fee\";s:5:\"value\";s:26:\"3% convenience fee applied\";s:11:\"display_key\";s:15:\"_last_added_fee\";s:13:\"display_value\";s:26:\"3% convenience fee applied\";}}}}','','','2022-09-06 02:32:43','2022-09-06 02:32:43','2022-09-06 02:32:43','2022-09-06 02:32:43','$','','0','rXLkSJHLTkO8daVreRDl1EfeV','','2','')