Blog personal de Vicent Cubells

Endevineu quin lloc web pot tenir una consulta sql com aquesta:

select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 1 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘EU’ union select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 2 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘NA’ union select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 3 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘AS’ union select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 4 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘SA’ union select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 5 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘OC’ union select mirror_list.location, mirror_list.name, mirror_list.link, mirror_countries.countryname, mirror_countries.continent, 6 as ‘o’ from mirror_list left join mirror_countries on (mirror_list.location = mirror_countries.location and mirror_countries.officialname = 1) where mirror_countries.continent = ‘AF’ order by o, countryname

Exacte!!