C
Size: a a a
C
В
В
C
l
СВ
l
¿
O
O
VL
JT
pN
SELECT * FROM "offers" INNER JOIN "offerTypes" ON "offerTypes"."id" = "offers"."offerTypeId" INNER JOIN "pictures" ON "pictures"."offerId" = "offers"."id" LEFT JOIN "offerToCategories" ON "offers"."id" = "offerToCategories"."offerId" INNER JOIN "categories" ON "categories"."id" = "offerToCategories"."categoryId" WHERE "offers"."id" IN (SELECT "offers"."id" FROM "offerToCategories" LEFT JOIN "offers" ON "offers"."id" = "offerToCategories"."offerId" AND "offerToCategories"."categoryId" = ?)
VL
SELECT * FROM "offers" INNER JOIN "offerTypes" ON "offerTypes"."id" = "offers"."offerTypeId" INNER JOIN "pictures" ON "pictures"."offerId" = "offers"."id" LEFT JOIN "offerToCategories" ON "offers"."id" = "offerToCategories"."offerId" INNER JOIN "categories" ON "categories"."id" = "offerToCategories"."categoryId" WHERE "offers"."id" IN (SELECT "offers"."id" FROM "offerToCategories" LEFT JOIN "offers" ON "offers"."id" = "offerToCategories"."offerId" AND "offerToCategories"."categoryId" = ?)
pN
VL
N
VL
pN
VL