select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('003E69AB-91F6-407C-8F38-EDC456429663', '65EBFA01-7744-4861-803E-BA026DFC9BA0', 'A44BDC33-9B13-40CE-AC68-9038B8C2BD3A', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('003E69AB-91F6-407C-8F38-EDC456429663', '65EBFA01-7744-4861-803E-BA026DFC9BA0', 'A44BDC33-9B13-40CE-AC68-9038B8C2BD3A', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
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` =8where `categoryid` ='357BBB4C-D608-4425-98B2-E92B90228D64'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5D315850-6D83-4E20-B8EE-2E3D67E44D60', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('5CCFA614-EC0A-4C46-BDA1-5B5874894DEB', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('357BBB4C-D608-4425-98B2-E92B90228D64', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DD00A79D-68F0-4377-89A6-EDABFD25BAFE', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'D644D14C-33BC-40B9-B9B3-20A0B78663C1') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc