select * from `web_setting`
                           where (`cid`>0 and `rang`>0)
                           order by `cid`,`rang`

select s.*, u.`pass`
	                              from `web_session` as s
	                              left join `web_user` as u on s.`user_id` = u.`id`
	                              inner join `web_group_access` as ga on ga.`group_id` = u.`group_id`
	                                   and ga.`attribut` = 'login' and ga.`value` = '1'
	                              where MD5(CONCAT(s.`sess`, s.`browser`)) = '5561cfae0d9ff1bec64f84f662df15e4' LIMIT 0,1

select `sess`
                                  from `web_session`
                                  where `user_id` = 0
	                                and MD5(CONCAT(`ip`, `browser`)) = '8bbf4d2bc5e4722e145e0536bea3c3f5' LIMIT 0,1

replace into `web_session` (`sess`,`ip`,`user_id`,`last_action`,`site`,`browser`)
                  values ('72520631e9facd6e0fc5a13180eac226','38.107.191.85',0,1283541119,'robots.txt','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')

delete from web_session
             where (user_id = "0" and last_action < "1283541119")
              or (user_id > 0 and  last_action < "1283541119")

SELECT s.*, t.`name` as tplname,t.`typ`
											FROM `web_style` AS s,
												`web_template_set` AS t
											WHERE s.`id` = 1
											AND t.`id` = s.`templateset` LIMIT 0,1

SELECT var.`name`, var.`default`, val.`replacement`
								FROM `web_lang_var` AS var
										LEFT JOIN `web_lang_value` AS val ON var.`id` = val.`var_id`,
										`web_lang_index` AS i,
										`web_lang_file` AS f
								WHERE f.`name` = 'index.php'
									AND i.`file_id` = f.`id`
									AND var.`id` = i.`var_id`
									AND (val.`lang_id` = 0 OR val.`lang_id` IS NULL)
								GROUP BY var.`id`

select * from `Content` as c
	                        inner join `SupportRubrik` as r on (r.`RubrikID` = c.`RubrikID` and r.`AID` = "" and r.`Rubrikname` = "" and r.`Public` = "yes")
	                        where c.`Head2` not in ("home","impressum") and c.`von` < now() and (c.`bis` > now() or c.`bis` is NULL or c.`bis` = "0000-00-00 00:00:00") and c.`Aktiv` = "aktiv"
	                        order by c.`von`

select * from `Content` as c
	                             inner join `SupportRubrik` as r on (r.`RubrikID` = c.`RubrikID` and r.`AID` = "" and r.`Rubrikname` = "" and r.`Public` = "yes")
	                             where c.`Head2` like "home" and c.`von` < now() and (c.`bis` > now() or c.`bis` is NULL or c.`bis` = "0000-00-00 00:00:00") and c.`Aktiv` = "aktiv"
	                             order by c.`von` desc LIMIT 0,1

SELECT s.id, s.templateset, s.variableset, t.typ, t.name
									FROM `web_style` AS s,
										`web_template_set` AS t
									WHERE s.templateset = 0
										AND t.id = s.templateset