Взуття для хлопчиків

Фільтр по:

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 (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 = 4 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 = 36 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 = 37 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) 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 = 44 AND EXISTS ( SELECT 1 FROM products_colors pc JOIN all_filters_filters_items affi ON affi.pid = pc.pid_with WHERE pc.pid IN (199692, 199694, 199696, 199698, 199700, 199702, 199704, 199706, 390734, 390738, 390740, 399830, 421886, 421888, 421890, 464387, 464399) AND affi.fid = aff.translationId ) ORDER BY aff.heading_contact ASC;