New search

home AF Armenia

Volver a ver todas las estanterías Collection générale

Dentro de la estantería Collection générale hay diferentes estantes, haga clic encima para explorarlos...
folderGéographie, histoire, sciences auxiliaires de l'histoirefolderLangagefolderLes arts. Beaux arts et arts décoratifs
folderLittérature (Belles lettres)folderNo clasificadofolderPhilosophie, parapsychologie et occultisme, psychologie
folderReligionfolderSciences SocialesfolderSciences de la nature et mathématiques : classer ici les sciences naturelles, les ouvrages sur les sciences pures et appliquées. Classer
folderTechniques (Sciences appliquées)  

1261 resultado(s)
    Refinar búsqueda

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='48333' AND nbec.arc_expl_bulletin='0') 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_notice!=48333 AND oal.arc_id_empr !=0 GROUP BY oal.arc_expl_notice, oal.arc_expl_bulletin HAVING total_prets>=10 ORDER BY rand()