SELECT *, IF(Id in (select id_producto from trans_promociones), '0', '1') as x , IF(articulo in (select codigo from trans_new), '0', '1') as n FROM productos where publicado = 'Y' and id_subcategoria = '5' and id_categoria = '2' order by n , articulo desc