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 ORDER BY d.date_add DESC
✅ Camisetas de JUEGO DE TRONOS y otros productos - Pag: 1 - Coladitos
Tu Inventario

Subtotal EUR

Descuentos EUR

Envio GRATIS

TOTAL (IVA incluido) EUR

Comprar Ir al inventario
Tu Inventario

¡Añade a tu inventario cosas molonas!

¿No sabes qué añadir?

Descubrir nuevos diseños

Camisetas de juego de tronos

MÁS TAGS

Colores

Previsualización

Tags relacionados

Keep calm and bend the knee Por AsyramDesign
The night king Por Nekuta
Fight for the crown Por Robertisto
Sorry ladies Por Momo-meme
Men in black Por Momo-meme
Mostrando 5 resultados de 5
1
Página 1 de 1
Mostrando 5 resultados de 5
X