arg... cnp error
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 26 Jul 2005 17:48:12 +0000 (17:48 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 26 Jul 2005 17:48:12 +0000 (17:48 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@1499 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm

index 2613387..caaf4c0 100644 (file)
@@ -202,7 +202,7 @@ sub global_record_copy_count {
                                  FROM  $cn_table cn
                                        JOIN $cp_table cp ON (cn.id = cp.call_number)
                                        JOIN $cs_table cs ON (cs.id = cp.status)
-                                       JOIN $cl_table cs ON (cl.id = cp.location)
+                                       JOIN $cl_table cl ON (cl.id = cp.location)
                                  WHERE cn.record = ?
                                        AND cp.status = 0
                                        $copies_visible
@@ -212,7 +212,7 @@ sub global_record_copy_count {
                                  FROM  $cn_table cn
                                        JOIN $cp_table cp ON (cn.id = cp.call_number)
                                        JOIN $cs_table cs ON (cs.id = cp.status)
-                                       JOIN $cl_table cs ON (cl.id = cp.location)
+                                       JOIN $cl_table cl ON (cl.id = cp.location)
                                  WHERE cn.record = ?
                                        $copies_visible
                                  GROUP BY 1