Introducing the new Reconn-Deck™ Crossbar fitment for cap/toppers, carefully crafted with a sleek and rugged design that looks stylish on even the tou...
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('3125C8C7-C50A-45F6-876D-3AD3A6C7CB98', '838B96C5-689B-49B7-B43D-1E5019D7670F', '499E3B9F-89E8-451A-A350-4146CB75A09E', 'F3666E39-9AA7-478D-8C6A-35685DCBC9A0', '6ABC6F0E-EB01-4828-A525-D6D7AD2E006B')
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` =5where `categoryid` ='7AD59A98-5926-4F33-80F6-EB0B44E38FDA'and `PR_ProductCategories`.`deleted_at` isnull
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'B1305FA3-BCD1-4663-99C4-270F93282DD7', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'B1305FA3-BCD1-4663-99C4-270F93282DD7', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '843D9E97-48A1-4EB9-A971-CAEE74D9AB40', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '843D9E97-48A1-4EB9-A971-CAEE74D9AB40', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select*from `PR_Products` where `PR_Products`.`productId` in ('329024C9-D30E-4E5E-8D14-7B4ED4F1F590', '6490CA18-A82B-4B2B-A388-CF490B477463') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('6490CA18-A82B-4B2B-A388-CF490B477463', '329024C9-D30E-4E5E-8D14-7B4ED4F1F590') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('6490CA18-A82B-4B2B-A388-CF490B477463', '329024C9-D30E-4E5E-8D14-7B4ED4F1F590') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'EEA4B69A-1CCE-4922-86C1-36AF29282EE4', '6CF41DEE-58F1-481B-ABE0-D14AC67C28E4', '7AD59A98-5926-4F33-80F6-EB0B44E38FDA', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'EEA4B69A-1CCE-4922-86C1-36AF29282EE4', '6CF41DEE-58F1-481B-ABE0-D14AC67C28E4', '7AD59A98-5926-4F33-80F6-EB0B44E38FDA', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('238668D3-0625-4459-866C-E0FE697D8ACF', '6490CA18-A82B-4B2B-A388-CF490B477463', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '6490CA18-A82B-4B2B-A388-CF490B477463', '238668D3-0625-4459-866C-E0FE697D8ACF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =5) and `isActive` =1orderby `lngId` desc