Difference between revisions of "CCSP"
| Line 5: | Line 5: | ||
table=dziOrder,dziCase | table=dziOrder,dziCase | ||
|join on=dziOrder._pageName=dziCase.dziorder | |join on=dziOrder._pageName=dziCase.dziorder | ||
| − | |fields=CONCAT('{{dziThumbnail{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=Case,dziCase.clinical_hx=Clinical Hx,dziCase.case_diagnosis=Diagnosis,dziOrder.collection_name=Subspecialty,dziOrder.requested_by=Faculty,CONCAT('{{ListSize{{#urldecode:%7C}}{{CaseSlidesQuery{{#urldecode:%7C}}',dziCase._pageName,'}} }}')=Slide Count | + | |fields=CONCAT('{{dziThumbnail{{#urldecode:%7C}}',dziCase._pageTitle,'}}')=Case,dziCase.clinical_hx=Clinical Hx,dziCase.case_diagnosis=Diagnosis,dziOrder.collection_name=Subspecialty,dziOrder.requested_by=Faculty,CONCAT('{{ListSize{{#urldecode:%7C}}{{CaseSlidesQuery{{#urldecode:%7C}}',dziCase._pageName,'}} }}')=Slide Count,CONCAT('{{dziCasecheckbox{{#urldecode:%7C}}',_pageTitle,'}}')=QC |
|where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' | |where=dziOrder.class_name='CME' AND dziOrder.class_type='CCSP' AND dziOrder.cme_subspec='2019' | ||
|order by=Subspecialty ASC|details fields=Diagnosis | |order by=Subspecialty ASC|details fields=Diagnosis | ||
Revision as of 06:54, October 27, 2019
2019
Query: SELECT CONCAT('{{dziThumbnail|',`cargo__dziCase`.`_pageTitle`,'}}') AS `Case`,`cargo__dziCase`.`clinical_hx` AS `Clinical Hx`,`cargo__dziCase`.`case_diagnosis` AS `Diagnosis`,`cargo__dziOrder`.`collection_name` AS `Subspecialty`,`cargo__dziOrder`.`requested_by` AS `Faculty`,CONCAT('{{ListSize|{{CaseSlidesQuery|',`cargo__dziCase`.`_pageName`,'}} }}') AS `Slide Count`,CONCAT('{{dziCasecheckbox|',_pageTitle,'}}') AS `QC` FROM `cargo__dziOrder` LEFT OUTER JOIN `cargo__dziCase` ON ((`cargo__dziOrder`.`_pageName`=`cargo__dziCase`.`dziorder`)) WHERE `cargo__dziOrder`.`class_name`='CME' AND `cargo__dziOrder`.`class_type`='CCSP' AND `cargo__dziOrder`.`cme_subspec`='2019' ORDER BY `Subspecialty` LIMIT 100000 Function: CargoSQLQuery::run Error: 1052 Column '_pageTitle' in SELECT is ambiguous (172.27.81.126:30004)
2018
No results
