select id, name, url, guideurl, guidelink, guidecontent, guidebox, guidetitle, ghtmltitle, htmldesciption, tabletitle, what, who, wherefield, whenfield, how, type, why, time, language, preparation, cost, guidemetadescription, guidekeywordsdesc, guidedescription, practicetesturl, toppagelinks from categories where id=24 and enabled is not null
select name, value from publiccontent where page='All Pages' or page='All Pages'
select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle from adsdesc where status is null and categoryid=24 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=24 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=24 union all select adid, link, image, imgtitle, imgalt, rank+100, showgoogle from ad where status is null and rank is not null order by rank limit 10
2023 Edition
select name, value from publiccontent where page='All Pages' or page='All Pages'
select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle from adsdesc where status is null and categoryid=24 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=24 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=24 union all select adid, link, image, imgtitle, imgalt, rank+100, showgoogle from ad where status is null and rank is not null order by rank limit 10
2023 Edition