Lines 632-637
sub get_saved_reports_base_query {
Link Here
|
632 |
SELECT s.*, $area_name_sql_snippet, av_g.lib AS groupname, av_sg.lib AS subgroupname, |
632 |
SELECT s.*, $area_name_sql_snippet, av_g.lib AS groupname, av_sg.lib AS subgroupname, |
633 |
b.firstname AS borrowerfirstname, b.surname AS borrowersurname |
633 |
b.firstname AS borrowerfirstname, b.surname AS borrowersurname |
634 |
FROM saved_sql s |
634 |
FROM saved_sql s |
|
|
635 |
LEFT JOIN saved_reports r ON r.report_id = s.id |
635 |
LEFT OUTER JOIN authorised_values av_g ON (av_g.category = 'REPORT_GROUP' AND av_g.authorised_value = s.report_group) |
636 |
LEFT OUTER JOIN authorised_values av_g ON (av_g.category = 'REPORT_GROUP' AND av_g.authorised_value = s.report_group) |
636 |
LEFT OUTER JOIN authorised_values av_sg ON (av_sg.category = 'REPORT_SUBGROUP' AND av_sg.lib_opac = s.report_group AND av_sg.authorised_value = s.report_subgroup) |
637 |
LEFT OUTER JOIN authorised_values av_sg ON (av_sg.category = 'REPORT_SUBGROUP' AND av_sg.lib_opac = s.report_group AND av_sg.authorised_value = s.report_subgroup) |
637 |
LEFT OUTER JOIN borrowers b USING (borrowernumber) |
638 |
LEFT OUTER JOIN borrowers b USING (borrowernumber) |
638 |
- |
|
|