Query Template: /product/listings/put_options.cfm:15 Execution Time: 7.97 ms
Record Count: 6 Cached: No Datasource: hockeywolf_2021 Lazy: No SQL:
SELECT * from Order_no N LEFT JOIN Order_items OI ON N.order_no = OI.order_no WHERE N.settingID = 1 AND OI.product_ID = 10267
|
| Order_No | Filled | Process | Void | InvDone | Customer_ID | User_ID | Card_ID | ShipTo | DateOrdered | OriginalTotal | OrderTotal | Tax | ShipType | Shipping | Freight | Comments | AuthNumber | InvoiceNum | TransactNum | Shipper | Tracking | Giftcard | Delivery | OrderDisc | Credits | AddonTotal | Coup_Code | Cert_Code | Affiliate | Referrer | IPAddress | Abandoned | Weight | CustomText1 | CustomText2 | CustomText3 | CustomSelect1 | CustomSelect2 | DateFilled | PayPalStatus | Reason | OfflinePayment | PO_Number | Notes | Admin_Updated | Admin_Name | AdminCredit | AdminCreditText | Printed | Printed_Inv | Printed_Pack | Status | Status2 | Paid | CodesSent | ID_Tag | TermsUsed | LastTransactNum | ShippingLabel | ReturnLabel | Actual_shipping | IsAddressVerified | Source | Easypostshipmentid | Easypostshipmentid_return | QB_export | QB_Customer_ID | QBProcess | OLD_orderID | Amazon_OrderID | Amazon_Order_Filled | giftCertDisc | Printed_quote | Ship_coup_code | ShippingDisc | Amazon_Fees | Subscribe_SMS_shipping | Subscription_id | cus_shipper | cus_shipping_acc | cus_shipping_method | SettingID | adminuser_id | Avatax_Transaction_Code | Team_Order | Account_Rep | instoreSettingId | Paid_not_delivered | PIN_employee | PIN_manager | employeeUserId | employeeUserName | ach_ID | Item_ID | Product_ID | Options | Addons | AddonMultP | AddonNonMultP | Price | Quantity | Quantity_Shipped | OptPrice | UPC | ALU | SKU | OptQuant | OptChoice | OptionID_List | ChoiceID_List | DiscAmount | Disc_Code | PromoAmount | PromoQuant | Promo_Code | Name | Dropship_Account_ID | Dropship_Qty | Dropship_SKU | Dropship_Cost | Dropship_Note | Per_Item_Weight | Editable | SKU_ID | sm_image | Amazon_OrderItemID | DateAdded_to_basket | Hide_in_Cart | Certificate_Number | Subscription_period | Subscription_discount | PackageNum | PackageParent | Category_id | ParentCat | ParentCatName | sortno |
1 | 44984 | 1 | 1 | 0 | 1 | 73093 | 46999 | 17736 | 0 | {ts '2020-08-05 18:07:46'} | 264.98 | 264.98 | 0 | Ground Shipping | 14.99 | 0 | | 074465 | 202044334493345 | 5551430601 | | | | | 0 | 0 | 0 | | | 0 | Unknown | 172.68.38.55 | 0 | 0 | | | | Friend | | {ts '2020-09-21 18:23:20'} | | | Online | | | {ts '2020-09-21 18:23:20'} | Traver McLeod | 0 | | 0 | 0 | 0 | | | 1 | 1 | 0A1601F800E34C1697D8308EE3B4ED78 | | 5551430601 | | | 0 | 0 | Web | | | 0 | | 0 | | | 0 | | 0 | | 0 | | 1 | 0 | | | | 1 | | | 0 | | 1 | 0 | | | | | | 1 | 10267 | Choose One::Medium | | 0 | 0 | 249.99 | 1 | 1 | 0 | 495180443936 | | | 15749 | 2 | 15749 | 2 | 0 | | 0 | 0 | | Bauer GSX Chest Protector Sr | | 0 | | 148.72 | | 0 | | | | | | 0 | | 0 | 0 | | 0 | 0 | | | |
2 | 46757 | 1 | 1 | 0 | 1 | 76022 | 48801 | 19156 | 76021 | {ts '2020-10-19 14:41:40'} | 365 | 365 | 0 | No Shipping | 0 | 0 | | 847670 | 202027844603044 | 5725639275 | | | | | 0 | 0 | 0 | | | 0 | Unknown | 172.68.150.27 | 0 | 0 | | | | | | {ts '2020-10-19 14:41:40'} | | | Online | | | | | 0 | | 0 | 0 | 0 | | | 1 | 1 | 0A57B02DF10E46ACB28D1527D950929C | | 5725639275 | | | 0 | 0 | POS | | | 0 | | 0 | | | 0 | 0 | 0 | | | | 0 | 0 | | | | 1 | | | 0 | | 1 | 0 | | | | | | 2 | 10267 | Choose One::Medium | | 0 | 0 | 165 | 1 | 1 | 0 | 495180443936 | | | 15749 | 2 | 15749 | 2 | 0 | | 0 | 0 | | Bauer GSX Chest Protector Sr | | 0 | | 148.72 | | 0 | | | | | | 0 | | 0 | 0 | | 0 | 0 | | | |
3 | 50472 | 1 | 1 | 0 | 1 | 83182 | 53024 | 22283 | 83181 | {ts '2021-01-30 13:14:59'} | 1084.95 | 1294.96 | 0 | No Shipping | 0 | 0 | | 03736P | 202171351461562 | 5970228136 | | | | | 0 | 0 | 0 | | | 0 | Unknown | 108.162.245.215 | 0 | 0 | | | | | | {ts '2021-02-12 17:15:09'} | | | Online | | <br />PAYMENT 02/12/2021, AuthNumber 08711P. | {ts '2021-02-12 17:16:25'} | Tucker Sargent | 0 | | 0 | 1 | 0 | | | 1 | 1 | D89C931703B345AE9EE1D668D8A55430 | | 5970228136 | | | 0 | 0 | POS | | | 0 | | 0 | | | 0 | 0 | 0 | | | | 0 | 0 | | | | 1 | | | 0 | | 1 | 0 | | | | | | 5 | 10267 | Choose One::Large | | 0 | 0 | 249.99 | 1 | 1 | 0 | 495180443936 | | | 15749 | 3 | 15749 | 3 | 0 | | 0 | 0 | | Bauer GSX Chest Protector Sr | | 0 | | 148.72 | | 0 | | | | | | 0 | | 0 | 0 | | 0 | 0 | | | |
4 | 51071 | 1 | 1 | 0 | 1 | 84326 | 53686 | 22791 | 84325 | {ts '2021-02-17 18:30:24'} | 324.98 | 324.98 | 0 | No Shipping | 0 | 0 | | 987487 | 202175936470135 | 6017529516 | | | | | 0 | 0 | 0 | | | 0 | Unknown | 172.68.150.115 | 0 | 0 | | | | | | {ts '2021-02-17 18:30:24'} | | | Online | | | | | 0 | | 0 | 1 | 0 | | | 1 | 1 | E36BE201F953495E8842BD1E52A474C3 | | 6017529516 | | | 0 | 0 | POS | | | 0 | | 0 | | | 0 | 0 | 0 | | | | 0 | 0 | | | | 1 | | | 0 | | 1 | 0 | | | | | | 2 | 10267 | Choose One::Large | | 0 | 0 | 174.99 | 1 | 1 | 0 | 495180443936 | | | 15749 | 3 | 15749 | 3 | 0 | | 0 | 0 | | Bauer GSX Chest Protector Sr | | 0 | | 148.72 | | 0 | | | | | | 0 | | 0 | 0 | | 0 | 0 | | | |
5 | 116118 | 1 | 1 | 0 | 1 | 86224 | 0 | 64769 | 0 | {ts '2023-07-10 00:28:19'} | 307.48 | 307.48 | 0 | In-Store Pickup - Hockeywolf Missoula | 0 | 0 | | 175631 | 3VXBO0gK1msMsjjD9tqpDeQPCcSZY | 3VXBO0gK1msMsjjD9tqpDeQPCcSZY | | | | | 0 | 0 | 0 | | | 0 | Unknown | 47.215.225.170 | 0 | 0 | | | | | | {ts '2023-07-16 18:13:29'} | | | Online | | <p>LYN contacted 7/10; customer called checking status 7/16</p>
| {ts '2023-07-16 18:13:29'} | Northgate Station 2 | 0 | | 0 | 0 | 0 | | | 1 | 1 | 427E44A0BD764D2183753FC9539976DE | | 3VXBO0gK1msMsjjD9tqpDeQPCcSZY | | | 0 | 0 | WEB | | | 0 | | 0 | | | 0 | | 0 | | 0 | | 1 | 0 | | | | 1 | | | 0 | | 1 | 0 | | | | | | 1 | 10267 | Choose One::Large | | 0 | 0 | 187.49 | 1 | 1 | 0 | 688698418149 | | | 15749 | 3 | 15749 | 3 | 0 | | 0 | 0 | | Bauer GSX Senior Goal Chest Protector | | 0 | | 148.72 | | 0 | | | products/10267/BAUERGSXChestProtectorSenior_sm.webp | | {ts '2023-07-10 00:18:52'} | 0 | | 0 | 0 | | 0 | 0 | 647 | Chest & Arm | 0 |
6 | 147279 | 1 | 1 | 0 | 1 | 193324 | 147872 | 92708 | 193324 | {ts '2024-02-18 16:55:18'} | 809.99 | 809.99 | 0 | 0 | 0 | 0 | | 0 | 202459475026587 | | | | | | 0 | 0 | 0 | | | 0 | Unknown | 2600:6cf2:a100:44c:2592:2688:619:9809 | 0 | 0 | | | | | | {ts '2024-02-18 16:55:18'} | | | Online | | | | | 0 | | 0 | 1 | 0 | | | 1 | 1 | 21ABEB9F3DFD46129CF85E39BE72BE46 | | | | | 0 | 0 | POS | | | 0 | | 0 | | | 0 | 0 | 0 | | | | 0 | 0 | | | | 1 | 56757 | | 0 | | 1 | 0 | | | | | | 3 | 10267 | Choose One::Small | | 0 | 0 | 180 | 1 | 1 | 0 | 688698418163 | | | 15749 | 1 | 15749 | 1 | 0 | | 0 | 0 | | Bauer GSX Senior Goal Chest Protector | | 0 | | 148.72 | | 0 | | | products/10267/BAUERGSXChestProtectorSenior_sm.webp | | | 0 | | 0 | 0 | | 0 | 0 | 0 | | 0 |