Get country tags and their frequency

Please login or register to vote for this query.

(click on this box to dismiss)
Q&A for professional and enthusiast programmers
SELECT 
Tags.tagname, count(PostTags.TagId) as no
FROM 
  PostTags, Tags
WHERE 
Tags.Id = PostTags.TagId AND tagname ='lithuania' OR
Tags.Id = PostTags.TagId AND tagname ='luxembourg' OR
Tags.Id = PostTags.TagId AND tagname ='montenegro' OR
Tags.Id = PostTags.TagId AND tagname ='northern-cyprus' OR
Tags.Id = PostTags.TagId AND tagname ='san-marino' OR
Tags.Id = PostTags.TagId AND tagname ='switzerland' OR
Tags.Id = PostTags.TagId AND tagname ='united-kingdom' OR
Tags.Id = PostTags.TagId AND tagname ='republic-of-ireland' OR
Tags.Id = PostTags.TagId AND tagname ='belgium' OR
Tags.Id = PostTags.TagId AND tagname ='bulgaria' OR
Tags.Id = PostTags.TagId AND tagname ='cyprus' OR
Tags.Id = PostTags.TagId AND tagname ='denmark' OR
Tags.Id = PostTags.TagId AND tagname ='estonia' OR
Tags.Id = PostTags.TagId AND tagname ='finland' OR
Tags.Id = PostTags.TagId AND tagname ='france' OR
Tags.Id = PostTags.TagId AND tagname ='germany' OR
Tags.Id = PostTags.TagId AND tagname ='andorra' OR
Tags.Id = PostTags.TagId AND tagname ='armenia' OR
Tags.Id = PostTags.TagId AND tagname ='belarus' OR
Tags.Id = PostTags.TagId AND tagname ='hungary' OR
Tags.Id = PostTags.TagId AND tagname ='czech-republic' OR
Tags.Id = PostTags.TagId AND tagname ='georgia-(country)' OR
Tags.Id = PostTags.TagId AND tagname ='latvia' OR
Tags.Id = PostTags.TagId AND tagname ='liechtenstein' OR
Tags.Id = PostTags.TagId AND tagname ='iceland' OR
Tags.Id = PostTags.TagId AND tagname ='malta' OR
Tags.Id = PostTags.TagId AND tagname ='moldova' OR
Tags.Id = PostTags.TagId AND tagname ='monaco' OR
Tags.Id = PostTags.TagId AND tagname ='netherlands' OR
Tags.Id = PostTags.TagId AND tagname ='norway' OR
Tags.Id = PostTags.TagId AND tagname ='poland' OR
Tags.Id = PostTags.TagId AND tagname ='portugal' OR
Tags.Id = PostTags.TagId AND tagname ='romania' OR
Tags.Id = PostTags.TagId AND tagname ='russia' OR
Tags.Id = PostTags.TagId AND tagname ='serbia' OR
Tags.Id = PostTags.TagId AND tagname ='slovakia' OR
Tags.Id = PostTags.TagId AND tagname ='slovenia' OR
Tags.Id = PostTags.TagId AND tagname ='spain' OR
Tags.Id = PostTags.TagId AND tagname ='sweden' OR
Tags.Id = PostTags.TagId AND tagname ='vatican-city' OR
Tags.Id = PostTags.TagId AND tagname ='albania' OR
Tags.Id = PostTags.TagId AND tagname ='austria' OR
Tags.Id = PostTags.TagId AND tagname ='azerbaijan' OR
Tags.Id = PostTags.TagId AND tagname ='croatia' OR
Tags.Id = PostTags.TagId AND tagname ='greece' OR
Tags.Id = PostTags.TagId AND tagname ='italy' OR
Tags.Id = PostTags.TagId AND tagname ='republic-of-macedonia' OR
Tags.Id = PostTags.TagId AND tagname ='ukraine' OR
Tags.Id = PostTags.TagId AND tagname ='republic-of-kosovo' OR
Tags.Id = PostTags.TagId AND tagname ='argentina' OR
Tags.Id = PostTags.TagId AND tagname ='venezuela' OR
Tags.Id = PostTags.TagId AND tagname ='brazil' OR
Tags.Id = PostTags.TagId AND tagname ='chile' OR
Tags.Id = PostTags.TagId AND tagname ='bolivia' OR
Tags.Id = PostTags.TagId AND tagname ='colombia' OR
Tags.Id = PostTags.TagId AND tagname ='ecuador' OR
Tags.Id = PostTags.TagId AND tagname ='guyana' OR
Tags.Id = PostTags.TagId AND tagname ='paraguay' OR
Tags.Id = PostTags.TagId AND tagname ='suriname' OR
Tags.Id = PostTags.TagId AND tagname ='uruguay' OR
Tags.Id = PostTags.TagId AND tagname ='peru' OR
Tags.Id = PostTags.TagId AND tagname ='cape-verde' OR
Tags.Id = PostTags.TagId AND tagname ='central-african-republic' OR
Tags.Id = PostTags.TagId AND tagname ='equatorial-guinea' OR
Tags.Id = PostTags.TagId AND tagname ='guinea-bissau' OR
Tags.Id = PostTags.TagId AND tagname ='madagascar' OR
Tags.Id = PostTags.TagId AND tagname ='mozambique' OR
Tags.Id = PostTags.TagId AND tagname ='seychelles' OR
Tags.Id = PostTags.TagId AND tagname ='south-africa' OR
Tags.Id = PostTags.TagId AND tagname ='swaziland' OR
Tags.Id = PostTags.TagId AND tagname ='the-gambia' OR
Tags.Id = PostTags.TagId AND tagname ='botswana' OR
Tags.Id = PostTags.TagId AND tagname ='comoros' OR
Tags.Id = PostTags.TagId AND tagname ='ethiopia' OR
Tags.Id = PostTags.TagId AND tagname ='ghana' OR
Tags.Id = PostTags.TagId AND tagname ='angola' OR
Tags.Id = PostTags.TagId AND tagname ='benin' OR
Tags.Id = PostTags.TagId AND tagname ='burkina-faso' OR
Tags.Id = PostTags.TagId AND tagname ='burundi' OR
Tags.Id = PostTags.TagId AND tagname ='côte-divoire' OR
Tags.Id = PostTags.TagId AND tagname ='democratic-republic-of-the-congo' OR
Tags.Id = PostTags.TagId AND tagname ='djibouti' OR
Tags.Id = PostTags.TagId AND tagname ='egypt' OR
Tags.Id = PostTags.TagId AND tagname ='eritrea' OR
Tags.Id = PostTags.TagId AND tagname ='gabon' OR
Tags.Id = PostTags.TagId AND tagname ='kenya' OR
Tags.Id = PostTags.TagId AND tagname ='lesotho' OR
Tags.Id = PostTags.TagId AND tagname ='libya' OR
Tags.Id = PostTags.TagId AND tagname ='morocco' OR
Tags.Id = PostTags.TagId AND tagname ='niger' OR
Tags.Id = PostTags.TagId AND tagname ='nigeria' OR
Tags.Id = PostTags.TagId AND tagname ='republic-of-the-congo' OR
Tags.Id = PostTags.TagId AND tagname ='rwanda' OR
Tags.Id = PostTags.TagId AND tagname ='senegal' OR
Tags.Id = PostTags.TagId AND tagname ='sudan' OR
Tags.Id = PostTags.TagId AND tagname ='tanzania' OR
Tags.Id = PostTags.TagId AND tagname ='togo' OR
Tags.Id = PostTags.TagId AND tagname ='tunisia' OR
Tags.Id = PostTags.TagId AND tagname ='uganda' OR
Tags.Id = PostTags.TagId AND tagname ='zambia' OR
Tags.Id = PostTags.TagId AND tagname ='zimbabwe' OR
Tags.Id = PostTags.TagId AND tagname ='cameroon' OR
Tags.Id = PostTags.TagId AND tagname ='liberia' OR
Tags.Id = PostTags.TagId AND tagname ='malawi' OR
Tags.Id = PostTags.TagId AND tagname ='mali' OR
Tags.Id = PostTags.TagId AND tagname ='mauritania' OR
Tags.Id = PostTags.TagId AND tagname ='mauritius' OR
Tags.Id = PostTags.TagId AND tagname ='namibia' OR
Tags.Id = PostTags.TagId AND tagname ='rodrigues' OR
Tags.Id = PostTags.TagId AND tagname ='sierra-leone' OR
Tags.Id = PostTags.TagId AND tagname ='somalia' OR
Tags.Id = PostTags.TagId AND tagname ='south-sudan' OR
Tags.Id = PostTags.TagId AND tagname ='western-sahara' OR
Tags.Id = PostTags.TagId AND tagname ='bangladesh' OR
Tags.Id = PostTags.TagId AND tagname ='british-indian-ocean-territory' OR
Tags.Id = PostTags.TagId AND tagname ='sri-lanka' OR
Tags.Id = PostTags.TagId AND tagname ='afghanistan' OR
Tags.Id = PostTags.TagId AND tagname ='bhutan' OR
Tags.Id = PostTags.TagId AND tagname ='india' OR
Tags.Id = PostTags.TagId AND tagname ='iran' OR
Tags.Id = PostTags.TagId AND tagname ='maldives' OR
Tags.Id = PostTags.TagId AND tagname ='nepal' OR
Tags.Id = PostTags.TagId AND tagname ='pakistan' OR
Tags.Id = PostTags.TagId AND tagname ='kyrgyzstan' OR
Tags.Id = PostTags.TagId AND tagname ='tajikistan' OR
Tags.Id = PostTags.TagId AND tagname ='uzbekistan' OR
Tags.Id = PostTags.TagId AND tagname ='china' OR
Tags.Id = PostTags.TagId AND tagname ='mongolia' OR
Tags.Id = PostTags.TagId AND tagname ='turkmenistan' OR
Tags.Id = PostTags.TagId AND tagname ='kazakhstan' OR
Tags.Id = PostTags.TagId AND tagname ='japan' OR
Tags.Id = PostTags.TagId AND tagname ='north-korea' OR
Tags.Id = PostTags.TagId AND tagname ='taiwan' OR
Tags.Id = PostTags.TagId AND tagname ='south-korea' OR
Tags.Id = PostTags.TagId AND tagname ='east-timor' OR
Tags.Id = PostTags.TagId AND tagname ='burma' OR
Tags.Id = PostTags.TagId AND tagname ='malaysia' OR
Tags.Id = PostTags.TagId AND tagname ='thailand' OR
Tags.Id = PostTags.TagId AND tagname ='yemen' OR
Tags.Id = PostTags.TagId AND tagname ='australia' OR
Tags.Id = PostTags.TagId AND tagname ='bahrain' OR
Tags.Id = PostTags.TagId AND tagname ='iraq' OR
Tags.Id = PostTags.TagId AND tagname ='israel' OR
Tags.Id = PostTags.TagId AND tagname ='jordan' OR
Tags.Id = PostTags.TagId AND tagname ='kuwait' OR
Tags.Id = PostTags.TagId AND tagname ='lebanon' OR
Tags.Id = PostTags.TagId AND tagname ='oman' OR
Tags.Id = PostTags.TagId AND tagname ='qatar' OR
Tags.Id = PostTags.TagId AND tagname ='saudi-arabia' OR
Tags.Id = PostTags.TagId AND tagname ='syria' OR
Tags.Id = PostTags.TagId AND tagname ='united-arab-emirates' OR
Tags.Id = PostTags.TagId AND tagname ='costa-rica' OR
Tags.Id = PostTags.TagId AND tagname ='guatemala' OR
Tags.Id = PostTags.TagId AND tagname ='nicaragua' OR
Tags.Id = PostTags.TagId AND tagname ='belize' OR
Tags.Id = PostTags.TagId AND tagname ='el-salvador' OR
Tags.Id = PostTags.TagId AND tagname ='honduras' OR
Tags.Id = PostTags.TagId AND tagname ='panama' OR
Tags.Id = PostTags.TagId AND tagname ='papua-new-guinea' OR
Tags.Id = PostTags.TagId AND tagname ='federated-states-of-micronesia' OR
Tags.Id = PostTags.TagId AND tagname ='fiji' OR
Tags.Id = PostTags.TagId AND tagname ='kiribati' OR
Tags.Id = PostTags.TagId AND tagname ='marshall-islands' OR
Tags.Id = PostTags.TagId AND tagname ='nauru' OR
Tags.Id = PostTags.TagId AND tagname ='new-zealand' OR
Tags.Id = PostTags.TagId AND tagname ='palau' OR
Tags.Id = PostTags.TagId AND tagname ='samoa' OR
Tags.Id = PostTags.TagId AND tagname ='solomon-islands' OR
Tags.Id = PostTags.TagId AND tagname ='tonga' OR
Tags.Id = PostTags.TagId AND tagname ='vanuatu' OR
Tags.Id = PostTags.TagId AND tagname ='tuvalu' OR
Tags.Id = PostTags.TagId AND tagname ='mexico' OR
Tags.Id = PostTags.TagId AND tagname ='usa' OR
Tags.Id = PostTags.TagId AND tagname ='uk' OR
Tags.Id = PostTags.TagId AND tagname ='canada' OR
Tags.Id = PostTags.TagId AND tagname = 'greenland' OR
Tags.Id = PostTags.TagId AND tagname = 'french-guiana' OR
Tags.Id = PostTags.TagId and tagname = 'new-zealand' OR
Tags.Id = PostTags.TagId and tagname = 'indonesia' OR
Tags.Id = PostTags.TagId and tagname = 'south-africa' OR
Tags.Id = PostTags.TagId and tagname = 'turkey' OR
Tags.Id = PostTags.TagId and tagname = 'vietnam' OR 
Tags.Id = PostTags.TagId and tagname = 'burma'
GROUP BY tagname
ORDER BY no desc
edited dec 27 13
created dec 21 13
andra
Enter Parameters

Options: Text-only results Include execution plan
Switch to meta site
Hold tight while we fetch your results
Results[:current/:total] Messages Graph Execution Plan
Download CSV Download XML
:records returned in :time ms:cached