Agendas - City & Short breaks

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 = 'pt' AND g.tipo =2 AND g.id_frontend = 1 AND ga.id_area = 5 GROUP BY ga.id_guias LIMIT 0, 6