Guías -

SELECT SQL_CALC_FOUND_ROWS g.id FROM guias g INNER JOIN guias_campos gc ON gc.id = g.id INNER JOIN guias2areas ga ON ga.id_guias = g.id WHERE gc.lingua = 'es' AND g.tipo =1 AND g.id_frontend = 1 AND ga.id_area = 2 GROUP BY ga.id_guias LIMIT 0, 6