|  |
Ejemplares(6)
| Código de barras | Signatura | Tipo de medio | Ubicación | Sección | Estado |
|---|---|---|---|---|---|
| 320-00000002039 | 813 JDL 130 ex. 2 | Livre | AF Armenia | Jeunesse | En préstamo hasta 02/06/2023 |
| 320-00000002043 | 813 JDL 130 ex. 3 | Livre | AF Armenia | Jeunesse | Disponible |
| 320-00000002044 | 813 JDL 130 ex. 4 | Livre | AF Armenia | Jeunesse | Disponible |
| 320-00000002045 | 813 JDL 130 ex. 5 | Livre | AF Armenia | Jeunesse | Disponible |
| 320-00000001935 | 813 JLD 130 ex.1 | Livre | AF Armenia | Jeunesse | Disponible |
| 500-00000002723 | 843 JLD 130 | Livre | AF Bucaramanga | Collection générale | Disponible |
No hay ningún artÃculo para este número.
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'if'
SELECT oal.arc_expl_notice, oal.arc_expl_bulletin, count(*) AS total_prets, trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if(mention_date, concat(' (',mention_date,')') ,if (date_date, concat(' (',date_format(date_date, '%d/%m/%Y'),')') ,'')))) as tit, if(notices_m.notice_id, notices_m.notice_id, notices_s.notice_id) as not_id FROM ((((pret_archive AS oal JOIN (SELECT distinct arc_id_empr FROM pret_archive nbec where (nbec.arc_expl_notice='0' AND nbec.arc_expl_bulletin='3979') AND nbec.arc_id_empr !=0) as nbec ON (oal.arc_id_empr=nbec.arc_id_empr and oal.arc_id_empr!=0 and nbec.arc_id_empr!=0)) LEFT JOIN notices AS notices_m ON arc_expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON arc_expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) WHERE oal.arc_expl_bulletin!=3979 AND oal.arc_id_empr !=0 GROUP BY oal.arc_expl_notice, oal.arc_expl_bulletin HAVING total_prets>=10 ORDER BY rand()