SELECT *, profesionales.name AS name, country.name AS country_name, country.code AS country_code
FROM profesionales
LEFT JOIN country ON (profesionales.country = country.code)
WHERE profesionales.country = 'mx' AND profesionales.city = 'el porvenir guerrero municipio de ramones'
ORDER BY profesionales.organization ASC
Viveros en el porvenir guerrero municipio de ramones