select*from `PR_ProductSpareParts` whereexists (select*from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpareParts`.`deleted_at` isnullorderby `order` asc
select `id`, `productId`, `stockCode`, `title`, `defaultImage`, `productPrice` from `PR_Products` where `PR_Products`.`productId` in ('148D36AF-3DCD-4C97-817F-2D2A241CDA86') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select*from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpecifications`.`deleted_at` isnull
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpecificationProperties`.`deleted_at` isnull
select*from `PR_PackageComponents` whereexists (select*from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc) and `PR_PackageComponents`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_PackageComponents`.`deleted_at` isnullorderby `order` asc
select*from `PR_BarTypeProductCompatibilities` innerjoin `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and PR_BarTypes.lngId=7and `PR_BarTypeProductCompatibilities`.`deleted_at` isnullorderby `PR_BarTypes`.`order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationPropertyId` in ('9DAB68AF-1462-455F-9B00-9C8FDE0F92AA', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyMasterDataId` in ('83CF2ACC-FFB0-4A5F-8FC2-43124C363BA1') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `order` asc
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('4A599B08-ED9A-4BF6-A40A-8051DF769342', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` =1and `PR_CategorySpecifications`.`deleted_at` isnullorderby `order` asc
select `title` from `PR_Specifications` where `specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_Products` where `PR_Products`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select*from `VM_Vehicles` where `vehicleId` in ('F35D8C7C-D12D-429E-8898-F6E73F6C3858') and `VM_Vehicles`.`deleted_at` isnulland (`VM_Vehicles`.`lngId` isnullor `VM_Vehicles`.`lngId` ='7') and `isActive` =1orderby `lngId` desc
select*from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('88DAF6DF-7F85-4372-833A-441700A2FA0A') and `VM_Manufacturers`.`deleted_at` isnulland (`VM_Manufacturers`.`lngId` isnullor `VM_Manufacturers`.`lngId` ='7') and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` ='B39D102F-E79F-4157-A73F-1E89E807870F'and `PR_ProductCategories`.`productId` isnotnulland `categoryId` in ('2B39426A-55C6-45D5-9418-5A79A0166DEA', '23C6863F-91C0-44EE-B8DB-949A42E96573', 'DBE8AFC5-A2D9-4715-BB32-79424DBECA14', 'F7380C9C-AF6D-4B3D-82C9-17E81216DCA2') and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('148D36AF-3DCD-4C97-817F-2D2A241CDA86') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `parentId` from `PR_Categories` where `categoryId` in ('4A599B08-ED9A-4BF6-A40A-8051DF769342', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` =7and `deleted_at` isnull
select*from `PR_CategoryProductImages` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` =7and `categoryId1` isnotnulland (`categoryId2` =''or `categoryId2` isnull) and `deleted_at` isnull
select `parentId` from `PR_Categories` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` =7and `deleted_at` isnull
select*from `PR_CategoryProductImages` where `categoryId` in ('3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `lngId` =7and (`categoryId1` =''or `categoryId1` isnull) and (`categoryId2` =''or `categoryId2` isnull) and `deleted_at` isnull
select*from `PR_ProductSpareParts` whereexists (select*from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpareParts`.`deleted_at` isnullorderby `order` asc
select `id`, `productId`, `stockCode`, `title`, `defaultImage`, `productPrice` from `PR_Products` where `PR_Products`.`productId` in ('148D36AF-3DCD-4C97-817F-2D2A241CDA86') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select*from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpecifications`.`deleted_at` isnull
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_ProductSpecificationProperties`.`deleted_at` isnull
select*from `PR_PackageComponents` whereexists (select*from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc) and `PR_PackageComponents`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and `PR_PackageComponents`.`deleted_at` isnullorderby `order` asc
select*from `PR_BarTypeProductCompatibilities` innerjoin `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B39D102F-E79F-4157-A73F-1E89E807870F') and PR_BarTypes.lngId=7and `PR_BarTypeProductCompatibilities`.`deleted_at` isnullorderby `PR_BarTypes`.`order` asc
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('4A599B08-ED9A-4BF6-A40A-8051DF769342', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` =1and `PR_CategorySpecifications`.`deleted_at` isnullorderby `order` asc
select `title` from `PR_Specifications` where `specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('4A599B08-ED9A-4BF6-A40A-8051DF769342', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isRoofRackCategory` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where (`categoryId` in ('4A599B08-ED9A-4BF6-A40A-8051DF769342', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `slug` ='reconn-deck-bars'or `slug` ='reconn-deck-bar') and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)