SELECT *
FROM lu_cache
WHERE title IN ('featurecache', 'stylecache', 'clubcache', 'teamcache', 'highratingcache', 'bannercache', 'networkcache', 'censorcache', 'smileycache', 'bbcodecache', 'lastrun', 'setting', 'usergroupcache', 'help')

SELECT phpcode, location, title
			FROM lu_plugin 
			WHERE active='1' AND location IN('news_start', 'news_news_prequery', 'news_newsloop', 'news_end', 'include_start', 'include_end')

SELECT * 
FROM lu_session 
WHERE userid = 0
	AND host = '38.103.63.59'
	AND idhash = '4ddf956b45c20b90bab8cb9ca0ca185b'
LIMIT 1

SELECT style.css, style.stylevars, style.styleid
			FROM lu_style AS style WHERE styleid='1'

SELECT language.languageid, language.langoptions, language.langcode, language.charset, language.imagedir, language.dateformat, language.timeformat, language.decimalsep, language.thousandsep, language.phrasetype_global 
			FROM lu_language AS language 
			WHERE languageid='1'

SELECT DISTINCT title, template 
		FROM lu_template 
		WHERE  title IN('navbar','header','footer','css','headinclude','rightside','tabbar','newsbit','NEWS','block','liveupdatebit','networkbit','searcharticles','sidebar','extrabar','forumextrabar','FORUM_FOOTER','FORUM_HEADER','topbar','headermenu','headerinclude','topratingnewsbit','ladder','ladderbit') 
			AND (styleid='1' OR styleid='1') 
			ORDER BY styleid DESC

SELECT hometeam.title AS homenickname, liveupdate.awayteam, liveupdate.hometeam, liveupdate.roundid, liveupdate.homescore, liveupdate.awayscore, liveupdate.matchid, liveupdate.competitionid, liveupdate.status, awayteam.title AS awaynickname 
		FROM lu_liveupdate AS liveupdate
		INNER JOIN lu_team AS hometeam ON liveupdate.hometeam = hometeam.teamid 
		INNER JOIN lu_team AS awayteam ON liveupdate.awayteam = awayteam.teamid 
		INNER JOIN lu_round AS round ON round.roundid = liveupdate.roundid 
		WHERE round.startdate < 1246590283 and round.enddate > 1246590283

SELECT ladder.* 
			FROM lu_ladder AS ladder 
			WHERE ladder.competitionid = '1' 
			AND ladder.seasonid = 2009

SELECT template, title 
			FROM lu_template 
			WHERE title = 'customextrabar' 
				AND (styleid='1' OR styleid='1')
				ORDER BY styleid DESC

SELECT count(*) AS count FROM lu_news AS news 
	INNER JOIN lu_competition AS competition ON competition.competitionid = news.competitionid



WHERE 1 AND active=1

ORDER BY newsdate DESC

SELECT news.*, news.newsdate AS dateline, competition.title AS competitiontitle FROM lu_news AS news 
	INNER JOIN lu_competition AS competition ON competition.competitionid = news.competitionid



WHERE 1 AND active=1
GROUP BY news.newsid
ORDER BY newsdate DESC LIMIT 0, 15

UPDATE lu_session 
			SET userid='0', host='38.103.63.59', 
			idhash='4ddf956b45c20b90bab8cb9ca0ca185b', lastactivity='1246590283', 
			location='/news.php', useragent='CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 
			styleid='1', loggedin='0', languageid='1' 
			WHERE sessionid='5a0877a07ef686d62cea50b1457420d1'