yes

notices index_wew index_sew notice_id

0 1 pmb_indexation_docnum_allfields 1 oui non default

notices_global_index infos_global index_infos_global num_notice yes notices_global_index infos_global index_infos_global num_notice notices index_wew index_sew notice_id 1

notices index_wew index_sew notice_id notices_global_index infos_global index_infos_global num_notice explnum explnum_index_wew explnum_index_sew explnum_notice yes or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

authors concat(author_name,', ',author_rejete) index_author author_id yes

function SELECT group_concat(distinct responsability_fonction SEPARATOR ',') as all_responsability_fonction from responsability

msg:203 msg:204 msg:congres_libelle

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

publishers ed_name index_publisher ed_id yes

'0000-00-00') order by year, index_serie, tnvol, index_sew]]>

'!!p!!' order by year, index_serie, tnvol, index_sew]]>

'0000-00-00') order by year, index_serie, tnvol, index_sew]]>

='!!p!!' order by year, index_serie, tnvol, index_sew]]>

year like '%!!p!!%' or

year like '%!!p!!%' and

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

collections collection_name index_coll collection_id

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

sub_collections sub_coll_name index_sub_coll sub_coll_id

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

series serie_name serie_index serie_id

code like '!!p!!%' or

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

titres_uniformes tu_name index_tu tu_id yes

explnum explnum_index_wew explnum_index_sew explnum_notice yes

notices n_gen index_n_gen notice_id

notices n_contenu index_n_contenu notice_id

notices n_resume index_n_resume notice_id

notices concat(n_gen,' ',n_contenu,' ',n_resume) concat(index_n_gen,index_n_contenu,index_n_resume) notice_id

0 opac_thesaurus_defaut select id_thesaurus, libelle_thesaurus from thesaurus order by libelle_thesaurus or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and select group_concat(langue_defaut SEPARATOR "','") as langue_defaut, 1 from thesaurus where id_thesaurus in (!!id_thesaurus!!) group by 2

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue in ('!!langue_defaut!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catdef add key (num_noeud)

drop table if exists catlg

create temporary table catlg as select num_noeud,libelle_categorie, index_categorie from noeuds, categories where categories.langue in ('!!lang!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

select notcateg_notice as notice_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from catdef left join catlg on catdef.num_noeud = catlg.num_noeud, notices_categories where notices_categories.num_noeud=catdef.num_noeud and ((!!where_term_1!!) or (catlg.num_noeud is null and !!where_term_2!!)) group by notice_id order by pert desc

catlg.categories catlg.libelle_categorie catlg.index_categorie catlg.num_noeud catdef.categories catdef.libelle_categorie catdef.index_categorie catdef.num_noeud

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue in ('!!langue_defaut!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catdef add key (num_noeud)

drop table if exists catlg

create temporary table catlg as select num_noeud,libelle_categorie, index_categorie from noeuds, categories where categories.langue in ('!!lang!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

select notcateg_notice as notice_id from catdef left join catlg on catdef.num_noeud = catlg.num_noeud, notices_categories where notices_categories.num_noeud=catdef.num_noeud and ((catlg.libelle_categorie like '!!p!!%') or (catlg.num_noeud is null and catdef.libelle_categorie like '!!p!!%')) group by notice_id

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue in ('!!langue_defaut!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catdef add key (num_noeud)

drop table if exists catlg

create temporary table catlg as select num_noeud,libelle_categorie, index_categorie from noeuds, categories where categories.langue in ('!!lang!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

select notcateg_notice as notice_id from catdef left join catlg on catdef.num_noeud = catlg.num_noeud, notices_categories where notices_categories.num_noeud=catdef.num_noeud and ((catlg.libelle_categorie like '%!!p!!') or (catlg.num_noeud is null and catdef.libelle_categorie like '%!!p!!')) group by notice_id

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue in ('!!langue_defaut!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catdef add key (num_noeud)

drop table if exists catlg

create temporary table catlg as select num_noeud,libelle_categorie, index_categorie from noeuds, categories where categories.langue in ('!!lang!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

select notcateg_notice as notice_id from catdef left join catlg on catdef.num_noeud = catlg.num_noeud, notices_categories where notices_categories.num_noeud=catdef.num_noeud and ((catlg.libelle_categorie='!!p!!') or (catlg.num_noeud is null and catdef.libelle_categorie='!!p!!')) group by notice_id

0 or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and 0 opac_thesaurus_defaut select id_thesaurus, libelle_thesaurus from thesaurus order by libelle_thesaurus select group_concat(langue_defaut SEPARATOR "','") as langue_defaut, 1 from thesaurus where id_thesaurus in (!!id_thesaurus!!) group by 2 select case valeur_param when '0' then '{0,0}' when '*' then '*' else concat('{0,',valeur_param,'}') end as limit_montant from parametres where sstype_param='auto_postage_search_nb_montant' and type_param='thesaurus' select case valeur_param when '0' then '{0,0}' when '*' then '*' else concat('{0,',valeur_param,'}') end as limit_montant from parametres where sstype_param='auto_postage_search_nb_descendant' and type_param='thesaurus'

drop table if exists catdef

create temporary table catdef as select num_noeud,path_word_categ,index_path_word_categ from noeuds, categories where categories.langue in ('!!langue_defaut!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catdef add key (num_noeud)

drop table if exists catlg

create temporary table catlg as select num_noeud,path_word_categ, index_path_word_categ from noeuds, categories where categories.langue in ('!!lang!!') and noeuds.num_thesaurus in (!!id_thesaurus!!) and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

select notcateg_notice as notice_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from catdef left join catlg on catdef.num_noeud = catlg.num_noeud, notices_categories where notices_categories.num_noeud=catdef.num_noeud and ((!!where_term_1!!) or (catlg.num_noeud is null and !!where_term_2!!)) group by notice_id order by pert desc

catlg.categories catlg.path_word_categ catlg.index_path_word_categ catlg.num_noeud catdef.categories catdef.path_word_categ catdef.index_path_word_categ catdef.num_noeud

drop table if exists catdef

create temporary table catdef as select uni.* from (select n.id_noeud,n.path from noeuds as n join noeuds as term on n.path like concat(term.path,'%') where n.path regexp concat('^',term.path,'(\/[0-9]+)!!limit_descendant!!$') and term.id_noeud = !!p!! union select n.id_noeud,n.path from noeuds as n join noeuds as term on term.path like concat(n.path,'%') where n.path != 0 and term.path regexp concat('^',n.path,'(\/[0-9]+)!!limit_montant!!$') and term.id_noeud = !!p!!)as uni

select distinct notcateg_notice as notice_id from catdef join notices_categories on catdef.id_noeud = notices_categories.num_noeud

0 deflt_concept_scheme SELECT id_item as id, value as lib FROM skos_fields_global_index WHERE code_champ=100 group by 1 order by 2 or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and searcher_records_concepts

or msg:operator_between_multiple_authorities_or msg:operator_between_multiple_authorities_and

indexint concat(indexint_name,' ',indexint_comment) index_indexint indexint_id

notices index_l index_matieres notice_id

lang SELECT group_concat(distinct code_langue SEPARATOR ',') as all_languages from notices_langues where type_langue=0

lang SELECT group_concat(distinct code_langue SEPARATOR ',') as all_languages from notices_langues where type_langue=1

msg:4057 msg:4010 msg:bulletin_query msg:articles_query

doctype SELECT group_concat(distinct typdoc SEPARATOR ',') as all_typdoc from notices order by all_typdoc

select orinot_id, orinot_nom from origine_notice order by orinot_nom

select id_notice_statut, gestion_libelle from notice_statut order by gestion_libelle

commentaire_gestion like '%!!p!!%' or

commentaire_gestion like '%!!p!!%' and

='!!p!!' and create_date<='!!p!! 23:59:59']]>

'!!p!! 23:59:59']]>

='!!p!!']]>

='!!p!!' and update_date<='!!p!! 23:59:59']]>

'!!p!! 23:59:59']]>

='!!p!!']]>

select distinct if(if(explnum_url,'URL',explnum_mimetype)!='',if(explnum_url,'URL',explnum_mimetype),''),if(if(explnum_url,'URL',explnum_mimetype)!='',if(explnum_url,'URL',explnum_mimetype),'Undefined') from explnum order by 1

select id_explnum_statut, gestion_libelle from explnum_statut order by gestion_libelle

select distinct notice_id from notices where lien like concat('%',replace('!!p!!','*','%'),'%') and lien!='' order by index_serie, tnvol, index_sew

eformat like '%!!p!!%' or

eformat like '%!!p!!%' and

msg:39 msg:40

0 select distinct userid, CONCAT(nom, ' ', prenom) from users order by 1

0 select map_echelle_id, map_echelle_name from map_echelles order by map_echelle_name

0 select map_projection_id, map_projection_name from map_projections order by map_projection_name

0 select map_ref_id, map_ref_name from map_refs order by map_ref_name

0 searcher_records_map_equinoxe 0

select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11 and contains(geomfromtext('!!p!!'),map_emprise_data) = 1 union select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and contains(geomfromtext('!!p!!'),map_emprise_data) = 1

select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11 and Area((map_emprise_data)) > Area(geomfromtext('!!p!!')) union select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and Area((map_emprise_data)) > Area(geomfromtext('!!p!!'))

select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11 and Area((map_emprise_data)) < Area(geomfromtext('!!p!!')) union select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and Area((map_emprise_data)) < Area(geomfromtext('!!p!!'))

select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11 and intersects(geomfromtext('!!p!!'),map_emprise_data) = 1 union select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2 and intersects(geomfromtext('!!p!!'),map_emprise_data)

select notice_id from notices where notice_id not in (select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11) and notice_id not in (select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2)

select distinct map_emprise_obj_num as notice_id from map_emprises where map_emprise_type=11 union select distinct notcateg_notice as notice_id from notices_categories join map_emprises on num_noeud = map_emprises.map_emprise_obj_num where map_emprise_type = 2

0 select id_formation, formation_name from nomenclature_formations order by formation_order

0 select id_type, type_name from nomenclature_types order by type_order

0

0

0

0

0

0

0

0

0

0 select id_instrument, instrument_code from nomenclature_instruments where instrument_standard=0 order by instrument_code, instrument_name

0 select id_instrument, instrument_code from nomenclature_instruments where instrument_standard=1 order by instrument_code, instrument_name

relationtypedown SELECT group_concat(distinct relation_type SEPARATOR ',') as all_relation_type from notices,notices_relations where linked_notice=notice_id

relationtypeup SELECT group_concat(distinct relation_type SEPARATOR ',') as all_relation_type from notices,notices_relations where linked_notice=notice_id order by

msg:39 msg:40

select idlocation,location_libelle from docs_location order by location_libelle

0 select surloc_id,surloc_libelle from sur_location order by surloc_libelle

select idsection,section_libelle from docs_section order by section_libelle

select idlender,lender_libelle from lenders order by lender_libelle

select idtyp_doc,tdoc_libelle from docs_type order by tdoc_libelle

select idstatut,statut_libelle from docs_statut order by statut_libelle

select idcode,codestat_libelle from docs_codestat order by codestat_libelle

expl_note like '%!!p!!%' or

expl_note like '%!!p!!%' and

expl_comment like '%!!p!!%' or

expl_comment like '%!!p!!%' and

='!!p!!' and exemplaires.create_date<='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE exemplaires.create_date>='!!p!!' and exemplaires.create_date<='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE exemplaires.create_date>='!!p!!' and exemplaires.create_date<='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE exemplaires.create_date>='!!p!!' and exemplaires.create_date<='!!p!! 23:59:59' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

'!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE exemplaires.create_date>'!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE exemplaires.create_date>'!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE exemplaires.create_date>'!!p!! 23:59:59' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE exemplaires.create_date>='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE exemplaires.create_date>='!!p!! 23:59:59' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE exemplaires.create_date>='!!p!! 23:59:59' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

'!!p!!' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE expl_date_depot > '!!p!!' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE expl_date_depot > '!!p!!' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE expl_date_depot > '!!p!!' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

= '!!p!!' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE expl_date_depot >= '!!p!!' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE expl_date_depot >= '!!p!!' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE expl_date_depot >= '!!p!!' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

'!!p!!' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE expl_date_retour > '!!p!!' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE expl_date_retour > '!!p!!' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE expl_date_retour > '!!p!!' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

= '!!p!!' GROUP BY notice_id) UNION (SELECT notice_id FROM notices JOIN bulletins ON bulletin_notice = notice_id JOIN exemplaires ON expl_bulletin = bulletin_id WHERE expl_date_retour >= '!!p!!' GROUP BY notice_id) UNION (SELECT analysis_notice AS notice_id FROM exemplaires JOIN analysis ON (expl_bulletin = analysis_bulletin AND expl_bulletin !=0) WHERE expl_date_retour >= '!!p!!' GROUP BY notice_id) UNION (SELECT notices.notice_id FROM exemplaires JOIN bulletins ON (expl_bulletin=bulletins.bulletin_id AND expl_bulletin!=0) JOIN notices ON (bulletins.num_notice=notices.notice_id AND bulletins.num_notice!=0) WHERE expl_date_retour >= '!!p!!' GROUP BY notice_id)) AS sub1 ORDER BY notice_id DESC]]>

0 select distinct userid, CONCAT(nom, ' ', prenom) from users order by 1

'!!p!!' order by index_serie, tnvol, index_sew) union (select distinct notice_id from bulletins join notices notb on num_notice=notb.notice_id where date_date>'!!p!!' order by index_serie, tnvol, index_sew)]]>

='!!p!!' order by index_serie, tnvol, index_sew) union (select distinct notice_id from bulletins join notices notb on num_notice=notb.notice_id where date_date>='!!p!!' order by index_serie, tnvol, index_sew)]]>

select notice_id, tit1 from notices, notice_statut where statut=id_notice_statut and niveau_biblio='s' and notice_visible_gestion=1 order by tit1, index_sew

select idlocation,location_libelle from docs_location order by location_libelle

0 select surloc_id,surloc_libelle from sur_location order by surloc_libelle

select archempla_id, archempla_libelle from arch_emplacement order by archempla_libelle

select archtype_id, archtype_libelle from arch_type order by archtype_libelle

select archstatut_id, archstatut_gestion_libelle from arch_statut order by archstatut_gestion_libelle

select idcaddie,name from caddie where type='NOTI' order by name 0 1 1 1 Oui non 1 1 Oui non

select idcaddie,name from caddie where type='EXPL' order by name 0 1 1 1 Oui non 1 1 Oui non

select idcaddie,name from caddie where type='BULL' order by name 0 1 1 1 Oui non 1 1 Oui non

searcher_records_pfield

notices_custom_champ=!!field!! and notices_custom_origine=notice_id and notices_custom_small_text like '%!!p!!%' or

notices_custom_champ=!!field!! and notices_custom_origine=notice_id and notices_custom_small_text like '%!!p!!%' and

searcher_records_pfield

notices_custom_champ=!!field!! and notices_custom_origine=notice_id and notices_custom_text like '%!!p!!%' or

notices_custom_champ=!!field!! and notices_custom_origine=notice_id and notices_custom_text like '%!!p!!%' and

'!!p!!' order by index_serie, tnvol, index_sew]]>

='!!p!!' order by index_serie, tnvol, index_sew]]>

'!!p!!' order by index_serie, tnvol, index_sew]]>

='!!p!!' order by index_serie, tnvol, index_sew]]>

'!!p!!' order by index_serie, tnvol, index_sew]]>

='!!p!!' order by index_serie, tnvol, index_sew]]>

expl_custom_small_text like '%!!p!!%' or

expl_custom_small_text like '%!!p!!%' and

expl_custom_text like '%!!p!!%' or

expl_custom_text like '%!!p!!%' and

'!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

= '!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

'!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

= '!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

'!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

= '!!p!!' AND expl_custom_origine=expl_id) LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) GROUP BY notice_id order by expl_cb, notices_m.index_serie, notices_m.tnvol, notices_m.index_sew, notices_s.index_serie, notices_s.tnvol, notices_s.index_sew]]>

authperso_index_infos_global LIKE '%!!p!!%' or

authperso_index_infos_global LIKE '%!!p!!%' and

notice_authperso_notice_num=notice_id and notice_authperso_authority_num = id_authperso_authority AND id_authperso_authority=authperso_custom_origine and authperso_custom_champ=!!field!! and authperso_custom_small_text like '%!!p!!%' or

notice_authperso_notice_num=notice_id and notice_authperso_authority_num = id_authperso_authority AND id_authperso_authority=authperso_custom_origine and authperso_custom_champ=!!field!! and authperso_custom_small_text like '%!!p!!%' and

notice_authperso_notice_num=notice_id and notice_authperso_authority_num = id_authperso_authority AND id_authperso_authority=authperso_custom_origine and authperso_custom_champ=!!field!! and authperso_custom_text like '%!!p!!%' or

notice_authperso_notice_num=notice_id and notice_authperso_authority_num = id_authperso_authority AND id_authperso_authority=authperso_custom_origine and authperso_custom_champ=!!field!! and authperso_custom_text like '%!!p!!%' and

'!!p!!' order by index_serie, tnvol, index_sew]]>

= '!!p!!' order by index_serie, tnvol, index_sew]]>

'!!p!!' order by index_serie, tnvol, index_sew]]>

= '!!p!!' order by index_serie, tnvol, index_sew]]>

'!!p!!' order by index_serie, tnvol, index_sew]]>

= '!!p!!' order by index_serie, tnvol, index_sew]]>

msg:expr_bool_query msg:284 msg:contient_tous_mots_query msg:contient_plus_un_mot_query msg:commence_par_query msg:finit_par_query msg:exactement_comme_query = > < >= <= msg:est_vide_query msg:pas_vide_query msg:authority_query msg:map_multisearch_aerasup msg:map_multisearch_aerainf msg:map_multisearch_intersects