Introducing the new Reconn-Deck™ our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughes...
Introducing the new Reconn-Deck™ our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughes...
Introducing the new Reconn-Deck™ our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughes...
Introducing the new Reconn-Deck™, our versatile truck bed system. Carefully crafted with a sleek and rugged design that looks stylish on even the toug...
Introducing the new Reconn-Deck™, our versatile truck bed system. Carefully crafted with a sleek and rugged design that looks stylish on even the toug...
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('9D51E4B1-5899-4A2B-BD38-20563B2C02DD', '8012C46E-833D-439A-8FEF-6DBC69459334', '467984E0-67A1-4F0E-8BB4-EA01CAA584F3', '0FAA9AE0-9B22-404C-90A1-9638DFE9205A', '154ADE36-7A7C-48EF-99FD-24022B9841AA')
selectMAX(`productPrice`) as max_price, MIN(`productPrice`) as min_price, count(*) as product_count from `PR_ProductCategories` innerjoin `PR_Products` on `PR_Products`.`productId` = `PR_ProductCategories`.`productId` and `PR_Products`.`isActive` =1and `isObsolete` isnulland `PR_Products`.`deleted_at` isnulland `PR_Products`.`lngId` =2where `categoryid` ='C7961B39-2FF4-48EB-AED1-32E04B6B1632'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E27C36B9-15DC-4563-896C-0329D70F3BC3') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', '5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', '5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', '5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E27C36B9-15DC-4563-896C-0329D70F3BC5') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'E27C36B9-15DC-4563-896C-0329D70F3BC4') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC4', 'DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC4', 'DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC4', 'DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E27C36B9-15DC-4563-896C-0329D70F3BC5') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC5', '8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E27C36B9-15DC-4563-896C-0329D70F3BC3') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C7961B39-2FF4-48EB-AED1-32E04B6B1632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =2) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E27C36B9-15DC-4563-896C-0329D70F3BC3', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc