gistfile1.sql

select tags.name, tree_nodes.id from tree_nodes inner join tags on tree_nodes.tag_id = tags.id  where tags.name in (
'afternoon tea',
'byob',
'bar',
'breakfast',
'brunch',
'cafe',
'catering',
'dj (facilities)',
'dinner',
'entertainment facilities',
'fireplace',
'karaoke (facilities)',
"kids' menu",
'lunch',
'no alcohol',
'outdoor area',
'outdoor dining',
'outdoor facilities',
'parking (free)',
'pinball',
'pool table',
'private rooms',
'restaurant & bar facilities',
'restaurant',
'rooftop',
'terrace/patio',
'wheelchair access',
'wireless (free)',
'al fresco',
'birthdays',
'business',
'celebrations',
'cocktails',
'dating',
'dinner & a show',
'fine dining',
"girls' night out",
'great views',
'happy hour',
'hen nights',
'just opened',
'late night',
'post-theatre',
'pre-theatre',
'quirky',
'romantic',
'speciality beers'
) order by FIELD(tags.name,'afternoon tea','byob','bar','breakfast','brunch','cafe','catering','dj (facilities)','dinner','entertainment facilities','fireplace','karaoke (facilities)',"kids' menu",'lunch','no alcohol','outdoor area','outdoor dining','outdoor facilities','parking (free)','pinball','pool table','private rooms','restaurant & bar facilities','restaurant','rooftop','terrace/patio','wheelchair access','wireless (free)','al fresco','birthdays','business','celebrations','cocktails','dating','dinner & a show','fine dining',"girls' night out",'great views','happy hour','hen nights','just opened','late night','post-theatre','pre-theatre','quirky','romantic','speciality beers')