0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

select 'Gold' as Metal,
       1 as Requires,
	   'Regular' as Source,
	   Name as Name
from (values('Socratic'), ('Stellar Question'), ('Great Question'), (
                            'Famous Question'), ('Illuminator'), ('Great Answer'), (
                            'Populist'), ('Reversal'), ('Unsung Hero'), ('Fanatic'), (
                            'Legendary'), ('Marshal'), ('Constable'), ('Sheriff'), (
                            'Steward'), ('Copy Editor'), ('Electorate'), ('Publicist')) Badge(Name) 
UNION ALL
select 'Silver' as Metal,
       1 as Requires,
	   'Regular' as Source,
	   Name as Name
from (values('Inquisitive'), ('Favorite Question'), ('Good Question'), (
                            'Notable Question'), ('Enlightened'), ('Refiner'), ('Generalist'), (
                            'Guru'), ('Good Answer'), ('Necromancer'), ('Tenacious'), (
                            'Constituent'), ('Pundit'), ('Enthusiast'), ('Epic'), ('Beta'), (
                            'Convention'), ('Outspoken'), ('Yearling'), ('Deputy'), ('Civic Duty'), (
                            'Reviewer'), ('Strunk & White'), ('Archaeologist'), ('Sportsmanship'), (
                            'Research Assistant'), ('Taxonomist'), ('Booster')) Badge(Name)
UNION ALL
select 'Bronze' as Metal,
       1 as Requires,
	   'Regular' as Source,
	   Name as Name
from (values('Altruist'), ('Benefactor'), ('Curious'), ('Investor'), (
                            'Nice Question'), ('Popular Question'), ('Promoter'), (
                            'Scholar'), ('Student'), ('Tumbleweed'), ('Explainer'), (
                            'Nice Answer'), ('Revival'), ('Self-Learner'), ('Teacher'), (
                            'Autobiographer'), ('Caucus'), ('Commentator'), ('Mortarboard'), (
                            'Precognitive'), ('Quorum'), ('Talkative'), ('Citizen Patrol'), (
                            'Cleanup'), ('Critic'), ('Custodian'), ('Disciplined'), (
                            'Editor'), ('Excavator'), ('Organizer'), ('Peer Pressure'), (
                            'Proofreader'), ('Suffrage'), ('Supporter'), ('Synonymizer'), (
                            'Tag Editor'), ('Vox Populi'), ('Analytical'), ('Announcer'), ('Informed')) Badge(Name)

view current version

edited dec 19 14

created jan 17 14 rolfl