HomeAbout The Blues Foundation

About the Foundation
Contact Us
News
Staff
Board of Directors
Board Voting
Legal and Financial

Press
Press Releases
Downloadable Logos

Sponsorship
The Blues Music Awards
International Blues Challenge
Contact

Website
Website Map
Privacy / Use Statement
Copyright
Trademark Notice
Website Advertising
Board Elections voting is not currently available.


select id,name from tblBoardYears where votingstart<=now() and votingend>=now()
select date_format(votingstart,'%Y-%m-%d'),name,description from tblBoardYears where votingstart>now() order by votingstart limit 1
select DisplayName,parentid from tblSubMenu where url='/boardvote/index.php'
select name,url,parentid from tblMajorMenu where id=1
select name,url,image,imagex,imagey from tblTopMenu where id=1
select MM.id,MM.name,MM.url,SM.id,SM.DisplayName,concat(if(SM.secure='Y','https://blues.org','http://blues.org'),SM.url),MM.sql from tblMajorMenu MM left join tblSubMenu SM on MM.id=SM.parentid where SM.display='Y' and MM.display='Y' and MM.parentid=1 order by MM.sortorder,SM.sortorder
select B.id,concat('
',if(B.url <> '',concat(''),''),''),if(B.url<>'','',''),adhtml from tblBanners B left join tblImageLibrary IL on B.imageid=IL.id left join tblBannerTypes BT on B.typeid=BT.id where BT.topmenuid=1 and startdate<=now() and enddate >=now() order by rand()
update tblBanners set viewcount=viewcount+1 where id=74
insert into tblBannerTrackingViews values(null,74,now())
update tblBanners set viewcount=viewcount+1 where id=355
insert into tblBannerTrackingViews values(null,355,now())
update tblBanners set viewcount=viewcount+1 where id=426
insert into tblBannerTrackingViews values(null,426,now())
select B.id,concat('') from tblBanners B left join tblImageLibrary IL on B.imageid=IL.id where typeid=1 and startdate<=now() and enddate>=now() order by rand() desc limit 1
update tblBanners set viewcount=viewcount+1 where id=421
insert into tblBannerTrackingViews values(null,421,now())