select tz_offset,tz_tformat_sql,tz_tformat_php,tz_dformat_sql,
	    tz_dformat_php
	from config

	select user.user_id from user,session ,user_group
	where hash='' and
	    user.user_id=session.user_id and
	    user.user_id=user_group.user_id and
	    user_group.group_id in (3,2) and
	    end_time>1337546323

    select count(*) from user_group
    where user_id='' and group_id=3

        select tz_offset,tz_tformat_sql,tz_tformat_php,tz_dformat_sql,
	    tz_dformat_php
	from config

select page_id,mode,navgroup,last_visit<'2012-05-01' from pages
    where substring_index(pages.name,'/',-1)='kb.php'

	select page_id,navgroup,last_visit<'2012-05-01' from pages
	    where (mode='' or mode is null) and
	    substring_index(pages.name,'/',-1)='kb.php'

    select title,header,footer,background,length(image1),
	length(image2),length(image3),length(image4),length(image5),
	length(bg_image),
	font_color,font_size,support_department,
	table1_bgcolor,table2_bgcolor,table3_bgcolor,
	table1_color,table2_color,table3_color,
	table1_bordercolor,table2_bordercolor,table3_bordercolor,
	meta,glossary_color,header_html
    from pages_properties
    where pages_properties.page_id=''

select length(header_img) from pages where page_id=''

    select length(header),header_align,length(footer),footer_align,
	footer_html,length(logo),toptable_color,bottomtable_color/*,
	textmain,textchat,length(mainimg),length(mainimg2)*/
    from navlinks where navgroup=''

    update pages set hits=hits+1,last_visit=now()
    where page_id=''

    select top_navigation,topnav_color,topnav_textcolor,
	links_color,powered,length(powered_img),navbutton_bg,powered_bg,fulltext_search_kb
    from config

Search Advanced Search

    select rate_answers,allow_email_articles,allow_print_articles,
	allow_save_articles,/*sort_by_rating,*/show_faq,
	show_lastmodified,allow_comments,show_topic_id,/*show_relevance,*/
	show_recent,recent_number,/*allow_update_notify,*/bar_bg,
	categ_numrows,seo_links,categs_sort,article_sort
    from kb_config

	select show_faq,table_bg,bar_bg,heading_fg,header_color,faq_by_rating,
	    kb_bg2,categs_sort
	from kb_config

	select category_id,name,description,icon,seo_url from help_categories
	where active in (1,2) and parent_id='0'
	order by sort asc

select column_number from kb_config

	select category_id,name,description,icon from help_categories
	where active in (1,2) and parent_id='0'
	order by sort asc

	select topics.topic_id
	from topics ,topics_categories,help_categories
	where access=1 and (((expires and expires>=curdate()) or not expires) and
    ((since and since<=curdate()) or not since)) and approved=1
	     and topics.topic_id=topics_categories.topic_id and
		topics_categories.category_id='0' and
		((topics_categories.category_id=help_categories.category_id and
		help_categories.active in (1,2)) or '0'=0)
	group by topics.topic_id

	select topics.topic_id,subject,left(body,255),short_content,body,
	    1 as score,topics.icon,topics.seo_url
	from topics ,topics_categories,help_categories
	where access=1 and (((expires and expires>=curdate()) or not expires) and
    ((since and since<=curdate()) or not since)) and approved=1
	     and topics.topic_id=topics_categories.topic_id and
		topics_categories.category_id='0' and
		((topics_categories.category_id=help_categories.category_id and
		help_categories.active in (1,2)) or '0'=0)
	group by topics.topic_id
        order by score desc,topics.sort asc,topics.subject asc
	limit 0,