Introducing the new Reconn-Deck™, our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughe...
Introducing the new Reconn-Deck™, our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughe...
Introducing the new Reconn-Deck™, our versatile ute tub system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughe...
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('65EBFA01-7744-4861-803E-BA026DFC9BA0', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('65EBFA01-7744-4861-803E-BA026DFC9BA0', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('6024D9B1-0D46-48C2-934F-6541BB04B02B', 'BDB99B83-7053-4913-94AA-4A53DBDE5668') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `title` asc, `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('3EE33F84-FE05-49AB-B6F6-125A03E7F96F', 'D8DF83DA-887D-4292-A29F-4EBAD05BE8CC', '678B060C-B428-493C-8E78-93BD2CFAA7BE', '0C022442-FD74-4D3E-A117-880A9E6AE2BA', '343F5B28-4F5B-457E-9267-E1E24AAB9FEF')
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` ='880C1E22-31DD-4AEF-B0AC-269279CD3984'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('8EA23896-2F60-43C3-AAE9-A14520012A11', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') 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 ('880C1E22-31DD-4AEF-B0AC-269279CD3984', '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 ('D644D14C-33BC-40B9-B9B3-20A0B78663C1', 'E3EBAB78-3BFE-4DD8-9FE5-704770C3FEAE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =2) and `isActive` =1orderby `lngId` desc