Шапки на хлопчиків

Фільтр по:

SELECT aff.translationId, aff.title, aff.img_icon, aff.img_icon2 FROM all_filters_filters aff WHERE aff.lang = 'uk' AND aff.pid = 18 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (81418, 180504, 238326, 238822, 238854, 239270, 243150, 370182, 371522, 439190, 451336, 452319, 453000, 453161, 453566, 461802, 472005) AND affi.fid = aff.translationId ) ORDER BY aff.heading_contact ASC; SELECT aff.translationId, aff.title, aff.img_icon, aff.img_icon2 FROM all_filters_filters aff WHERE aff.lang = 'uk' AND aff.pid = 2 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (81418, 180504, 238326, 238822, 238854, 239270, 243150, 370182, 371522, 439190, 451336, 452319, 453000, 453161, 453566, 461802, 472005) AND affi.fid = aff.translationId ) ORDER BY aff.heading_contact ASC; SELECT aff.translationId, aff.title, aff.img_icon, aff.img_icon2 FROM all_filters_filters aff WHERE aff.lang = 'uk' AND aff.pid = 3 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (81418, 180504, 238326, 238822, 238854, 239270, 243150, 370182, 371522, 439190, 451336, 452319, 453000, 453161, 453566, 461802, 472005) AND affi.fid = aff.translationId ) ORDER BY aff.heading_contact ASC; SELECT aff.translationId, aff.title, aff.img_icon, aff.img_icon2 FROM all_filters_filters aff WHERE aff.lang = 'uk' AND aff.pid = 1 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (81418, 180504, 238326, 238822, 238854, 239270, 243150, 370182, 371522, 439190, 451336, 452319, 453000, 453161, 453566, 461802, 472005) AND affi.fid = aff.translationId ) ORDER BY aff.heading_contact ASC;