Guides - Cultural and landscape tourism
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 = 'en'
AND g.tipo =1
AND g.id_frontend = 1
AND ga.id_area = 9
GROUP BY
ga.id_guias
LIMIT 6, 6
-
-
MINES AND GEOLOGY NORTHERN PORTUGAL
-
-
-
-