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

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

    select title,header,footer,background,length(bg_image),
	font_color,font_size,length(header_img),meta
    from pages
    where page_id=''

    select /*length(header),*/header_align,length(footer),footer_align,
	header_html,footer_html,length(logo),logo_align,toptable_color,bottomtable_color,
	topnav_textcolor,topnav_color,
	textmain,length(mainimg),length(mainimg2),toptable_color,bottomtable_color,
	length(main_footer),main_footer_align,active
    from navlinks

    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
    from config

	select name,url,color from navigation
	where active=1 and pub='1'
	order by sort asc

	select name,required,type,date_start,date_end,empty_default
	from form_fields
	where active=1 and type<>6 and register=1
	order by sort,field_id asc