SELECT d.id_design, lower(de.nick) as alias, lower(description) as description, lower(dl.name) as name_design, lower(dl.meta_title) as meta_title, lower(dl.meta_description) as meta_description, lower(group_concat(tl.name separator '-')) as tags, group_concat(td.priority separator '-') as priorities, group_concat(td.id_tag separator '-') as id_tags FROM design d INNER JOIN design_lang dl ON d.id_design = dl.id_design INNER JOIN designer de ON de.id_designer = d.id_designer INNER JOIN (SELECT id_design, id_product_type FROM product WHERE id_product_type = '1' GROUP BY id_design) as p ON d.id_design = p.id_design LEFT JOIN tag_design td ON td.id_design = d.id_design LEFT JOIN tag t ON t.id_tag = td.id_tag LEFT JOIN tag_lang tl ON tl.id_tag = t.id_tag AND tl.id_lang = '1' WHERE d.active = 1 AND d.deleted = 0 AND d.visible = 1 AND dl.id_lang = '1' AND ( LOWER(dl.name) LIKE 'juego de tronos' OR LOWER(description) LIKE 'juego de tronos' OR LOWER(meta_title) LIKE 'juego de tronos' OR LOWER(meta_description) LIKE 'juego de tronos' OR LOWER(tl.name) LIKE 'juego de tronos' OR LOWER(de.nick) LIKE 'juego de tronos' ) GROUP BY d.id_design
✅ Camisetas de JUEGO DE TRONOS y otros productos - Pag: 1 - Coladitos
