Query
Template: /var/sites/railo.editlib.org/reader/dsp_menu2016.cfm
Execution Time: 141 ms
Record Count: 6
Cached: No
Lazy: No
SQL:
SELECT
source_code, sourceissue_volume, sourceissue_number, paper_id,
COALESCE(sourceissue_image, source_image) as source_image,
CASE
WHEN sourceissue_title > '' THEN sourceissue_title
ELSE
source_title
END as source_title
FROM
Sources LEFT JOIN SourceIssues ON Sources.source_id = SourceIssues.sourceissue_source
LEFT JOIN Papers ON Sources.source_id = Papers.paper_source AND Papers.paper_type in ('EBOOK','REPORT','THESIS','DISSERTATION')
WHERE
EXISTS (
SELECT *
FROM
Papers LEFT JOIN ContentPartners
ON Papers.paper_contentpartner = ContentPartners.contentpartner_id
WHERE
(
ContentPartners.contentpartner_code <> 'ERIC' OR
ContentPartners.contentpartner_code IS NULL
) AND
Papers.paper_status = 'DL_PUBLISH' AND
(
Papers.paper_sourceissue = SourceIssues.sourceissue_id OR
Papers.paper_sourceissue IS NULL
) AND
Papers.paper_source = Sources.source_id AND
Papers.date_added > {d '2016-11-08'}
)
AND NOT EXISTS (
SELECT *
FROM
SourceIssues LaterSourceIssues
WHERE
LaterSourceIssues.sourceissue_source = SourceIssues.sourceissue_source AND
LaterSourceIssues.sourceissue_date > SourceIssues.sourceissue_date
)
ORDER BY
COALESCE(sourceissues.date_created, sources.date_created) desc, sourceissue_date DESC, source_title
 source_codesourceissue_volumesourceissue_numberpaper_idsource_imagesource_title
1RES2016174168sources/RES2016.jpgResearch Highlights in Technology and Teacher Education 2016
2JEMH254Jemh.gifJournal of Educational Multimedia and Hypermedia
3ITET41ITET.jpgIssues and Trends in Educational Technology
4JCAL326JCAL.jpgJournal of Computer Assisted Learning
5JTATE243jtate.jpgJournal of Technology and Teacher Education
6ELEARN20161ELEARN.pngE-Learn: World Conference on E-Learning