Rhino-Rack's Folding Aerial Bracket is designed with versatility in mind offering 180 degrees of rotation for aerials, antennas, flags, and spotlights...
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('BF0ABCE5-91D4-4A79-A682-BC9EC52559BB', '56BD5D58-4B71-4B9C-9606-A944743A92E2', '15D8B17A-0951-4585-9A20-3A9BB11A41FB')
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` =1where `categoryid` ='C73E1967-2005-49E9-8C6A-53525292CE0A'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('15D8B17A-0951-4585-9A20-3A9BB11A41FB', '56BD5D58-4B71-4B9C-9606-A944743A92E2', 'BF0ABCE5-91D4-4A79-A682-BC9EC52559BB') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =1) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C73E1967-2005-49E9-8C6A-53525292CE0A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('C73E1967-2005-49E9-8C6A-53525292CE0A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'C73E1967-2005-49E9-8C6A-53525292CE0A', '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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'C73E1967-2005-49E9-8C6A-53525292CE0A', '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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)