SELECT restaurants.provincia, count(restaurants.id) AS count_provincia FROM restaurants LEFT JOIN associations ON associations.restaurant_id = restaurants.id LEFT JOIN domains ON domains.id = associations.domain_id WHERE restaurants.enable='Y' AND upper(restaurants.regione)=E'SARDEGNA' AND ( domains.dominio='campeggi.sardegna.it' OR restaurants.categoria='campeggi' ) GROUP BY restaurants.provincia ORDER BY count_provincia DESC ; Content-type: text/html
Ricerca Campeggi Sardegna in Italia
