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=800 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=800 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=800 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=800 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
SELECT max(version) FROM examset WHERE productpageid in (select id from pagedata where page in (''cma-practice-exam''))
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cma-practice-exam''))' at line 1
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=800 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=800 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=800 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
SELECT max(version) FROM examset WHERE productpageid in (select id from pagedata where page in (''cma-practice-exam''))
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cma-practice-exam''))' at line 1
2023 Edition