SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_wol AS phrasegroup_wol,
phrasegroup_user AS phrasegroup_user,
phrasegroup_messaging AS phrasegroup_messaging,
phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_profilefield AS phrasegroup_profilefield,
phrasegroup_activitystream AS phrasegroup_activitystream,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1

SELECT title, template
FROM template
WHERE templateid IN (21595,24057,23979,23981,23985,23997,23995,23649,23651,23653,0,0,23655,0,0,23657,23667,23659,23661,23663,23669,23671,23673,23675,23677,23779,23783,23787,23791,23795,0,23891,23889,23895,23897,23903,23905,24389,24729,24741,24007,24003,24009,24013,24011,24015,24017,24019,24021,24023,24025,24027,24037,24031,24035,24029,24033,24055,24059,24061,24079,24043,24065,24067,24069,24071,24075,24001,24053,24063,24081,24073,24085,24083,24077,24237,16601,25469,25468,24891,14189,14188,14190,14185,14184,14951,14953,14949,14947,14193,14194,14961,24321,21591,16585,24221,24215,24217,16589,24929,0,0,24889,24811,24261,24263,24267,24269,24715,24953,24917,24817,24819,23915,23913,23921,21563,21565)