SELECT e.qstnset, e.pagename, e.testcomment, e.free, e.metatitle, e.metadesc, e.keywordsdesc,
ifnull(a.name,e.authorname1) authorname1, e.authorname2,
ifnull(a.email, e.authoremail) authoremail, ifnull(a.website,e.authorwebsite) authorwebsite,
a.bio, e.categoryid, e.completionmsg, e.authorwebtitle, e.authortitle, e.version, c.name catname, c.guideurl, c.dirtitle, c.dhtmltitle, c.htmldesciption, c.metadescription, c.keywordsdesc, c.categorydesc, c.htmldesciption, c.practicetesturl, c.toppagelinks, e.examname, e.copyright
FROM examset e
left outer join categories c on e.categoryid=c.id
left outer join examauthors a on e.authorid=a.authorid
WHERE e.offline is null and e.setname=? field (s) = Literature-Test SELECT q.qstnid, q.position, q.datatype, q.image, q.alignment, q.question, q.answerposn, q.answer, q.explanation, q.explainimage, q.section sectionid, s.name section, q.ad, q.storyid, x.title, x.story, x.image storyimage, x.imagealt storyalt
FROM examqstn q
LEFT OUTER JOIN examsections s on q.qstnset=s.qstnset and q.section=s.id
LEFT OUTER JOIN examstories x on q.qstnset=x.qstnset and q.storyid=x.storyid
WHERE q.qstnset=26 and (q.qstntype=3 or q.qstntype=1) and q.offline is null and q.disabled is null and q.datatype='1' ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=538 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2400 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2402 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2403 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2404 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2468 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2469 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2470 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2471 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2472 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2473 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2474 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2475 ORDER BY position SELECT choice, image FROM examchoices WHERE qstnid=2476 ORDER BY position select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=553
select page from pagedata where template like 'productpage%' and category=553
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=553
union all
select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle
from adsdesc
where status is null and parentid=553
union all
select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle
from adsdesc
where status is null and rootid=553
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 guidelink from categories where id=553 2023 Edition
Literature Test
If you are studying for a high school or college level literature exam, test or quiz, or just looking for a sample practice test to challenge your literary knowledge, take this free literature test and see how well you score. It is not a scientific assessment tool but it will give you an idea of what type of questions can be found on a literature exam and how well you know works, themes and authors.
select linkname, url, template, examid, viewid, pageid from categorylinks where catid=553 order by posn