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
