The MountainTrail fork mount bike carrier is a convenient option to safely secure your bike to the roof of your car. The universal mounting kit allows...
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0', '5E1E1476-3A49-4382-B513-48F318F3CB7D', 'C52506A2-E88D-4270-BCE6-4521A97D3785')
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` ='92962506-9FF0-4A88-83C3-2883165466E1'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0', '5E1E1476-3A49-4382-B513-48F318F3CB7D', 'C52506A2-E88D-4270-BCE6-4521A97D3785') 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '47C3547A-E35D-4143-ABBD-F2812A337BF1', '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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '47C3547A-E35D-4143-ABBD-F2812A337BF1', '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 ('92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '47C3547A-E35D-4143-ABBD-F2812A337BF1', '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 ('92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '47C3547A-E35D-4143-ABBD-F2812A337BF1', '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)