Tienda Online de Turrones Tienda Online de Turrones
home / familia / Tabletas y tortas
SELECT imagen FROM productos_x_color pc INNER JOIN productos p ON p.id = pc.producto WHERE p.activo = 1 AND pc.activo = 1 AND p.visible = 1 AND pc.visible = 1 AND imagen <> '' AND subfamilia = '1' ORDER BY p.orden ASC LIMIT 1 SELECT imagen FROM productos_x_color pc INNER JOIN productos p ON p.id = pc.producto WHERE p.activo = 1 AND pc.activo = 1 AND p.visible = 1 AND pc.visible = 1 AND imagen <> '' AND subfamilia = '2' ORDER BY p.orden ASC LIMIT 1
SELECT imagen FROM productos_x_color pc INNER JOIN productos p ON p.id = pc.producto WHERE p.activo = 1 AND pc.activo = 1 AND p.visible = 1 AND pc.visible = 1 AND imagen <> '' AND subfamilia = '3' ORDER BY p.orden ASC LIMIT 1
SELECT imagen FROM productos_x_color pc INNER JOIN productos p ON p.id = pc.producto WHERE p.activo = 1 AND pc.activo = 1 AND p.visible = 1 AND pc.visible = 1 AND imagen <> '' AND subfamilia = '4' ORDER BY p.orden ASC LIMIT 1