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` =5) and `isActive` =1orderby `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and `PR_ProductSpareParts`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and `PR_ProductSpecifications`.`deleted_at` isnull
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '50F360E9-8C0F-437E-A879-5685BEFF3827') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') 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` =5) and `isActive` =1orderby `lngId` desc) and `PR_PackageComponents`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') 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 ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and PR_BarTypes.lngId=5and `PR_BarTypeProductCompatibilities`.`deleted_at` isnullorderby `PR_BarTypes`.`order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationPropertyId` in ('40A339D4-C734-41BE-A9F5-7540C347B360', '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', '50F360E9-8C0F-437E-A879-5685BEFF3827') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyMasterDataId` in ('F1B13263-BFD0-457E-8483-82BAC86D607E') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `order` asc
selectcount(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` ='DA4005AE-E7FE-407D-A1E8-3B7DC8032711'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 `parentId` from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` =5and `deleted_at` isnull
select `parentId` from `PR_Categories` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', 'FC67EF35-A392-43B7-B0C4-EAD75456D932', 'B0234EF0-FA6F-4E71-962D-05BF9F5DB786', 'B0234EF0-FA6F-4E71-962D-05BF9F5DB786', 'A421D742-61EB-43C9-978F-43AADD8F611B', '19C339E4-2C6D-44FB-B685-FCA30DE60016') and `lngId` =5and `deleted_at` isnull
select*from `PR_CategoryProductImages` where `categoryId` in ('42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E') and `lngId` =5and (`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` =5) and `isActive` =1orderby `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and `PR_ProductSpareParts`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and `PR_ProductSpecifications`.`deleted_at` isnull
select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '50F360E9-8C0F-437E-A879-5685BEFF3827') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') 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` =5) and `isActive` =1orderby `lngId` desc) and `PR_PackageComponents`.`productId` in ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') 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 ('DA4005AE-E7FE-407D-A1E8-3B7DC8032711') and PR_BarTypes.lngId=5and `PR_BarTypeProductCompatibilities`.`deleted_at` isnullorderby `PR_BarTypes`.`order` asc
selectcount(*) as aggregate from `PR_Categories` where (`categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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 ('CFE8AF5E-8D96-4B45-9733-541C602AC29D', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('CFE8AF5E-8D96-4B45-9733-541C602AC29D', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` =5) and `isActive` =1and (`scope` isnullor `scope` =0)