select * from menu where menuparent=1 and securitylevel<=1 order by menuorder;select * from menu where menuparent=4 and securitylevel<=1 order by menuorder;
select * from menu where menuparent=104 order by menuorder;select * from menu where menuparent=112 order by menuorder;select * from menu where menuparent=124 order by menuorder;select * from menu where menuparent=125 order by menuorder;select * from menu where menuparent=111 order by menuorder;select * from menu where menuparent=109 order by menuorder;select * from menu where menuparent=127 order by menuorder;select * from menu where menuparent=128 order by menuorder;
select * from menu where menuparent=5 and securitylevel<=1 order by menuorder;
select * from menu where menuparent=126 order by menuorder;select * from menu where menuparent=98 order by menuorder;
select * from menu where menuparent=131 order by menuorder;select * from menu where menuparent=99 order by menuorder;
select * from menu where menuparent=129 order by menuorder;
select * from menu where menuparent=6 and securitylevel<=1 order by menuorder;
select * from menu where menuparent=19 order by menuorder;
select * from menu where menuparent=134 order by menuorder;select * from menu where menuparent=23 order by menuorder;select * from menu where menuparent=20 order by menuorder;select * from menu where menuparent=21 order by menuorder;select * from menu where menuparent=22 order by menuorder;select * from menu where menuparent=25 order by menuorder;
select * from menu where menuparent=7 and securitylevel<=1 order by menuorder;
select * from menu where menuparent=32 order by menuorder;select * from menu where menuparent=33 order by menuorder;
select * from menu where menuparent=34 order by menuorder;
select * from menu where menuparent=35 order by menuorder;
select * from menu where menuparent=8 and securitylevel<=1 order by menuorder;
select * from menu where menuparent=105 order by menuorder;select * from menu where menuparent=106 order by menuorder;select * from menu where menuparent=107 order by menuorder;
select * from menu where menuparent=9 and securitylevel<=1 order by menuorder;select * from menu where menuparent=10 and securitylevel<=1 order by menuorder;select * from menu where menuparent=11 and securitylevel<=1 order by menuorder;select * from menu where menuparent=12 and securitylevel<=1 order by menuorder;
SELECT * FROM poll where pollstartdate <='2010-3-11' AND pollenddate >='2010-3-11' order by pollstartdate desc;
Unit 1select * from menu where menuparent=5 and securitylevel<=1 order by menuorder;