SELECT p.* FROM paises p INNER JOIN produ_etiquetas e ON concat( 'url_', p.alias ) = e.de_nativo AND id_cuenta ='3' AND () UNION ALL Select * From paises  where alias='/flores/mexico/barra-vieja-acapulco/categoria-especial/10059-regalos-para-el'