Collection générale > Littérature (Belles lettres) > Generalidades

Dentro del tema Generalidades hay diferentes subtemas, haga clic encima para explorarlos...

Dictionnaires, encyclopédies, concordances	Etude et enseignement
Histoire, analyse, critique littéraires générales (et portant sur plus d'une littérature nationale)	No clasificado	Ouvrages divers
Philosophie et théorie	Publications en série	rhétorique et recueils : rhétorique : art et techniques de l'écriture et de l'expression orale. Classer ici le plagiat

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