Guías - Turismo cultural y Paisaje
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 = 9
GROUP BY
ga.id_guias
LIMIT 6, 6
-
-
MINAS Y GEOLOGÍA NORTE DE PORTUGAL
-
-
-
-