yes

notices index_wew index_sew notice_id

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

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

publishers ed_name index_publisher ed_id yes

'0000-00-00') and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where (date_parution<'!!p!!' and date_parution>'0000-00-00') AND bulletin_id = expl_bulletin and bulletin_notice=notice_id union select distinct expl_id from exemplaires, bulletins, notices where (date_parution<'!!p!!' and date_parution>'0000-00-00') AND bulletin_id = expl_bulletin and num_notice=notice_id union select distinct expl_id from exemplaires, notices,analysis,bulletins where (date_parution<'!!p!!' and date_parution>'0000-00-00') and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id]]>

'!!p!!') and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where (date_parution>'!!p!!') AND bulletin_id = expl_bulletin and bulletin_notice=notice_id union select distinct expl_id from exemplaires, bulletins, notices where (date_parution>'!!p!!') AND bulletin_id = expl_bulletin and num_notice=notice_id union select distinct expl_id from exemplaires, notices,analysis,bulletins where (date_parution>'!!p!!') and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id]]>

'0000-00-00') and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where (date_parution<='!!p!!' and date_parution>'0000-00-00') AND bulletin_id = expl_bulletin and bulletin_notice=notice_id union select distinct expl_id from exemplaires, bulletins, notices where (date_parution<='!!p!!' and date_parution>'0000-00-00') AND bulletin_id = expl_bulletin and num_notice=notice_id union select distinct expl_id from exemplaires, notices,analysis,bulletins where (date_parution<='!!p!!' and date_parution>'0000-00-00') and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id]]>

='!!p!!') and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where (date_parution>='!!p!!') AND bulletin_id = expl_bulletin and bulletin_notice=notice_id union select distinct expl_id from exemplaires, bulletins, notices where (date_parution>='!!p!!') AND bulletin_id = expl_bulletin and num_notice=notice_id union select distinct expl_id from exemplaires, notices,analysis,bulletins where (date_parution>='!!p!!') and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id]]>

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

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

collections collection_name index_coll collection_id

sub_collections sub_coll_name index_sub_coll sub_coll_id

series serie_name serie_index serie_id

code like '!!p!!%' or

titres_uniformes tu_name index_tu tu_id yes

explnum explnum_index_wew explnum_index_sew explnum_notice

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 select langue_defaut from thesaurus where id_thesaurus=!!id_thesaurus!!

drop table if exists catdef

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

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 categories where categories.langue='!!lang!!' and num_thesaurus = '!!id_thesaurus!!'

alter table catlg add key (num_noeud)

create temporary table t_mono_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,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!!)) and notcateg_notice=expl_notice

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

create temporary table t_bull_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,bulletins, notices, 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!!)) and notcateg_notice=num_notice AND bulletin_id = expl_bulletin and num_notice=notice_id

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

create temporary table t_depouille_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,bulletins, notices,analysis, 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!!)) and notcateg_notice=analysis_notice and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id

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

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue='!!langue_defaut!!' and noeuds.num_thesaurus = '!!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='!!lang!!' and noeuds.num_thesaurus = '!!id_thesaurus!!' and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

create temporary table t_mono_expl as select distinct expl_id from exemplaires,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!!%')) and notcateg_notice=expl_notice

create temporary table t_bull_expl as select distinct expl_id from exemplaires,bulletins, notices, 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!!%')) and notcateg_notice=num_notice AND bulletin_id = expl_bulletin and num_notice=notice_id

create temporary table t_depouille_expl as select distinct expl_id from exemplaires,bulletins, notices,analysis, 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!!%')) and notcateg_notice=analysis_notice and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue='!!langue_defaut!!' and noeuds.num_thesaurus = '!!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='!!lang!!' and noeuds.num_thesaurus = '!!id_thesaurus!!' and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

create temporary table t_mono_expl as select distinct expl_id from exemplaires,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!!')) and notcateg_notice=expl_notice

create temporary table t_bull_expl as select distinct expl_id from exemplaires,bulletins, notices, 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!!')) and notcateg_notice=num_notice AND bulletin_id = expl_bulletin and num_notice=notice_id

create temporary table t_depouille_expl as select distinct expl_id from exemplaires,bulletins, notices,analysis, 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!!')) and notcateg_notice=analysis_notice and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

drop table if exists catdef

create temporary table catdef as select num_noeud,libelle_categorie,index_categorie from noeuds, categories where categories.langue='!!langue_defaut!!' and noeuds.num_thesaurus = '!!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='!!lang!!' and noeuds.num_thesaurus = '!!id_thesaurus!!' and noeuds.id_noeud = categories.num_noeud

alter table catlg add key (num_noeud)

create temporary table t_mono_expl as select distinct expl_id from exemplaires,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!!')) and notcateg_notice=expl_notice

create temporary table t_bull_expl as select distinct expl_id from exemplaires,bulletins, notices, 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!!')) and notcateg_notice=num_notice AND bulletin_id = expl_bulletin and num_notice=notice_id

create temporary table t_depouille_expl as select distinct expl_id from exemplaires,bulletins, notices,analysis, 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!!')) and notcateg_notice=analysis_notice and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

create temporary table t_mono_expl as select distinct expl_id from exemplaires JOIN notices_categories ON notcateg_notice=expl_notice where notices_categories.num_noeud='!!p!!'

create temporary table t_bull_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id = expl_bulletin JOIN notices_categories ON num_notice=notcateg_notice where notices_categories.num_noeud='!!p!!'

create temporary table t_depouille_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN analysis ON analysis_bulletin=bulletin_id JOIN notices_categories ON notcateg_notice=analysis_notice where notices_categories.num_noeud='!!p!!'

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

create temporary table t_mono_expl as select distinct expl_id from exemplaires LEFT JOIN notices_categories ON notcateg_notice=expl_notice where notices_categories.num_noeud is null

create temporary table t_bull_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id = expl_bulletin LEFT JOIN notices_categories ON num_notice=notcateg_notice where notices_categories.num_noeud is null

create temporary table t_depouille_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN analysis ON analysis_bulletin=bulletin_id LEFT JOIN notices_categories ON notcateg_notice=analysis_notice where notices_categories.num_noeud is null

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

create temporary table t_mono_expl as select distinct expl_id from exemplaires JOIN notices_categories ON notcateg_notice=expl_notice

create temporary table t_bull_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id = expl_bulletin JOIN notices_categories ON num_notice=notcateg_notice

create temporary table t_depouille_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN analysis ON analysis_bulletin=bulletin_id JOIN notices_categories ON notcateg_notice=analysis_notice

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

0 opac_thesaurus_defaut select id_thesaurus, libelle_thesaurus from thesaurus order by libelle_thesaurus select langue_defaut from thesaurus where id_thesaurus=!!id_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_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 categories where categories.langue='!!langue_defaut!!' and num_thesaurus = '!!id_thesaurus!!'

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 categories where categories.langue='!!lang!!' and num_thesaurus = '!!id_thesaurus!!'

alter table catlg add key (num_noeud)

create temporary table t_mono_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,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!!)) and notcateg_notice=expl_notice

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

create temporary table t_bull_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,bulletins, notices, 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!!)) and notcateg_notice=num_notice AND bulletin_id = expl_bulletin and num_notice=notice_id

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

create temporary table t_depouille_expl as select distinct expl_id,if(catlg.num_noeud is null, !!pert_term_2!!, !!pert_term_1!!) as pert from exemplaires,bulletins, notices,analysis, 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!!)) and notcateg_notice=analysis_notice and analysis_bulletin=bulletin_id and bulletin_id=expl_bulletin and analysis_notice=notice_id

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

select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl

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

create temporary table t_mono_expl as select distinct expl_id from exemplaires JOIN notices_categories ON notcateg_notice=expl_notice JOIN catdef ON catdef.id_noeud=notices_categories.num_noeud

create temporary table t_bull_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id = expl_bulletin JOIN notices_categories ON num_notice=notcateg_notice JOIN catdef ON catdef.id_noeud=notices_categories.num_noeud

create temporary table t_depouille_expl as select distinct expl_id from exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN analysis ON analysis_bulletin=bulletin_id JOIN notices_categories ON notcateg_notice=analysis_notice JOIN catdef ON catdef.id_noeud=notices_categories.num_noeud

select * from (select * from t_mono_expl union select * from t_bull_expl union select * from t_depouille_expl) as uni group by uni.expl_id

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

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

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 notices.create_date<='!!p!! 23:59:59' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>='!!p!!' and notices.create_date<='!!p!! 23:59:59' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>='!!p!!' and notices.create_date<='!!p!! 23:59:59' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

'!!p!! 23:59:59' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>'!!p!! 23:59:59' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>'!!p!! 23:59:59' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

='!!p!!' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>='!!p!!' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.create_date>='!!p!!' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

='!!p!!' and notices.update_date<='!!p!! 23:59:59' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>='!!p!!' and notices.update_date<='!!p!! 23:59:59' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>='!!p!!' and notices.update_date<='!!p!! 23:59:59' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

'!!p!! 23:59:59' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>'!!p!! 23:59:59' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>'!!p!! 23:59:59' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

='!!p!!' and notice_id=expl_notice union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>='!!p!!' and bulletin_id = expl_bulletin and bulletin_notice = notice_id union select distinct expl_id from exemplaires, bulletins, notices where notices.update_date>='!!p!!' and bulletin_id = expl_bulletin and num_notice = notice_id ]]>

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

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

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

msg:39 msg:40

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

select idlocation,location_libelle from docs_location order by location_libelle

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 create_date<='!!p!! 23:59:59']]>

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

='!!p!!']]>

'!!p!!']]>

='!!p!!']]>

'!!p!!']]>

='!!p!!']]>

'!!p!!']]>

='!!p!!']]>

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

notices_custom_small_text like '%!!p!!%' or

notices_custom_small_text like '%!!p!!%' and

notices_custom_text like '%!!p!!%' or

notices_custom_text like '%!!p!!%' and

'!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_integer>'!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_integer>'!!p!!' AND num_notice=notices_custom_origine ]]>

='!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_integer>='!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_integer>='!!p!!' AND num_notice=notices_custom_origine ]]>

'!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND round(notices_custom_float,LENGTH(SUBSTRING_INDEX('!!p!!','.',-1)))>'!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND round(notices_custom_float,LENGTH(SUBSTRING_INDEX('!!p!!','.',-1)))>'!!p!!' AND num_notice=notices_custom_origine ]]>

='!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND round(notices_custom_float,LENGTH(SUBSTRING_INDEX('!!p!!','.',-1)))>='!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND round(notices_custom_float,LENGTH(SUBSTRING_INDEX('!!p!!','.',-1)))>='!!p!!' AND num_notice=notices_custom_origine ]]>

'!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_date>'!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_date>'!!p!!' AND num_notice=notices_custom_origine ]]>

='!!p!!' AND expl_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_date>='!!p!!' AND bulletin_notice=notices_custom_origine UNION SELECT DISTINCT expl_id FROM exemplaires JOIN bulletins ON bulletin_id=expl_bulletin JOIN notices_custom_values ON notices_custom_champ=!!field!! AND notices_custom_date>='!!p!!' AND num_notice=notices_custom_origine ]]>

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!!']]>

= '!!p!!']]>

'!!p!!']]>

= '!!p!!']]>

'!!p!!']]>

= '!!p!!']]>

pret_custom_small_text like '%!!p!!%' or

pret_custom_small_text like '%!!p!!%' and

pret_custom_text like '%!!p!!%' or

pret_custom_text like '%!!p!!%' and

'!!p!!']]>

= '!!p!!']]>

'!!p!!']]>

= '!!p!!']]>

'!!p!!']]>

= '!!p!!']]>

expl_id 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