select distinct notice_id, !!pert_term!! as pert from notices join notices_categories on (notice_id=notcateg_notice) join categories on (notices_categories.num_noeud=categories.num_noeud) where (!!where_term!!) order by index_serie,tnvol,index_sew

categories libelle_categorie index_categorie num_noeud

publishers ed_name index_publisher publisher_id

collections collection_name index_coll collection_id

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

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

publishers ed_name index_publisher publisher_id

collections collection_name index_coll collection_id

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

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

select uni.notice_id, pert, index_serie,tnvol,index_sew from ( select distinct notice_id, !!pert_term!! as pert from notices join notices_categories on (notice_id=notcateg_notice) join categories on (notices_categories.num_noeud=categories.num_noeud) join exemplaires on expl_notice=notice_id where (!!where_term!!) and expl_location=!!location!! UNION select distinct notice_id, !!pert_term!! as pert from notices join notices_categories on (notice_id=notcateg_notice) join categories on (notices_categories.num_noeud=categories.num_noeud) join bulletins on bulletin_notice=notice_id join exemplaires on expl_bulletin=bulletin_id where (!!where_term!!) and expl_location=!!location!! ) as uni ,notices where uni.notice_id=notices.notice_id order by index_serie,tnvol,index_sew

categories libelle_categorie index_categorie num_noeud select uni.notice_id, pert, index_serie,tnvol,index_sew from ( select distinct notice_id, !!pert_term!! as pert from notices join publishers on ((ed1_id=ed_id) or (ed2_id=ed_id)) join exemplaires on expl_notice=notice_id where (!!where_term!!) and expl_location=!!location!! and expl_section=!!section!! UNION select distinct notice_id, !!pert_term!! as pert from notices join bulletins on bulletin_notice=notice_id join exemplaires on expl_bulletin=bulletin_id join publishers on ((ed1_id=ed_id) or (ed2_id=ed_id)) where (!!where_term!!) and expl_location=!!location!! and expl_section=!!section!! ) as uni, notices where uni.notice_id=notices.notice_id order by index_serie,tnvol,index_sew publishers ed_name index_publisher publisher_id

collections collection_name index_coll collection_id

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

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

select uni.notice_id, pert, index_serie,tnvol,index_sew from ( select distinct notice_id, !!pert_term!! as pert from notices join notices_categories on (notice_id=notcateg_notice) join categories on (notices_categories.num_noeud=categories.num_noeud) join exemplaires on expl_notice=notice_id where (!!where_term!!) and expl_location=!!location!! and expl_section=!!section!! UNION select distinct notice_id, !!pert_term!! as pert from notices join notices_categories on (notice_id=notcateg_notice) join categories on (notices_categories.num_noeud=categories.num_noeud) join bulletins on bulletin_notice=notice_id join exemplaires on expl_bulletin=bulletin_id where (!!where_term!!) and expl_location=!!location!! and expl_section=!!section!! ) as uni ,notices where uni.notice_id=notices.notice_id order by index_serie,tnvol,index_sew

categories libelle_categorie index_categorie num_noeud

code like '!!p!!%' or

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

searcher_records_concepts

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

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

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