select distinct uni.typdoc, sum(nbexplnum) as nbexplnum from (select distinct notices.typdoc, count(explnum_id) as nbexplnum from notices left join explnum on explnum_mimetype in () and explnum_notice = notice_id ,notice_statut where (ed1_id='1408' or ed2_id='1408') and statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)) group by notices.typdoc union select distinct notices.typdoc, count(explnum_id) as nbexplnum from notices left join bulletins on bulletins.num_notice = notice_id and bulletins.num_notice != 0 left join explnum on explnum_mimetype in () and explnum_bulletin != 0 and explnum_bulletin = bulletin_id ,notice_statut where (ed1_id='1408' or ed2_id='1408') and statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)) group by notices.typdoc) as uni group by uni.typdoc
select * from aut_link where (aut_link_from='3' and aut_link_from_num='1408') order by aut_link_type, aut_link_string_start_date, aut_link_string_end_date, aut_link_rank
Éditeur faber and faber
Documents disponibles chez cet éditeur (3)
Ajouter le résultat dans votre panier Faire une suggestion
texte imprimé
A plane crashes on a desert island and the only survivors, a group of schoolboys, assemble on the beach and wait to be rescued. By day they inhabit a land of bright fantastic birds and dark blue seas, but at night their dreams are haunted by the[...]
texte imprimé
George III's behaviour has often been odd, but now he is deranged, with rumours circulating that he has even addressed an oak tree as the King of Prussia. Doctors are brought in, the government wavers and the Prince Regent manoeuvres himself int[...]
texte imprimé
A beautiful and haunting evocation of life between the wars in a Great English House, of lost causes and lost love.
