1016 -

SELECT filename, updated_at from ( SELECT p.products_image AS filename, 0 AS orden, products_last_modified as updated_at FROM products p WHERE p.products_id = '4214' AND p.products_image IS NOT NULL AND p.products_image != '' AND p.products_image != 'NULL' UNION SELECT pimg.image AS filename, sort_order as orden, file_last_modified as updated_at FROM products_images pimg WHERE pimg.products_id = '4214' order by orden asc) as imagenes group by filename order by orden

[TEP STOP]