Lines 299-308
sub calculate {
Link Here
|
299 |
|
299 |
|
300 |
# Processing average loanperiods |
300 |
# Processing average loanperiods |
301 |
$strcalc .= "SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS `RANK`, biblio.biblionumber AS ID"; |
301 |
$strcalc .= "SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS `RANK`, biblio.biblionumber AS ID"; |
302 |
$strcalc .= ", itemcallnumber as CALLNUM"; |
302 |
$strcalc .= ", GROUP_CONCAT(DISTINCT itemcallnumber) as CALLNUM"; |
303 |
$strcalc .= ", ccode as CCODE"; |
303 |
$strcalc .= ", GROUP_CONCAT(DISTINCT ccode) as CCODE"; |
304 |
$strcalc .= ", location as LOC"; |
304 |
$strcalc .= ", GROUP_CONCAT(DISTINCT location) as LOC"; |
305 |
$strcalc .= " , $colfield " if ($colfield); |
305 |
$strcalc .= " , GROUP_CONCAT(DISTINCT $colfield) " if ($colfield); |
306 |
$strcalc .= " FROM `old_issues` |
306 |
$strcalc .= " FROM `old_issues` |
307 |
LEFT JOIN items USING(itemnumber) |
307 |
LEFT JOIN items USING(itemnumber) |
308 |
LEFT JOIN biblio USING(biblionumber) |
308 |
LEFT JOIN biblio USING(biblionumber) |
309 |
- |
|
|