Tienda Online de Turrones Tienda Online de Turrones
home / familia / Porciones
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 = '19' 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 = '20' 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 = '21' 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 = '22' ORDER BY p.orden ASC LIMIT 1