Query
Template: /var/sites/railo.editlib.org/reader/dsp_menu2016.cfm
Execution Time: 5330 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-12-18'}
)
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
1JTATE244174261jtate.jpgJournal of Technology and Teacher Education
2IJEDICT123IJEDICT.jpgInternational Journal of Education and Development using ICT
3JILR274JILR.gifJournal of Interactive Learning Research
4OP84OP.pngOpen Praxis
5JOLR23JOLR.pngJournal of Online Learning Research
6AJET326ajet.jpgAustralasian Journal of Educational Technology