entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

i_value like '%!!p!!%' or

i_value like '%!!p!!%' and

'!!p!!'*1) and (ufield='210' and usubfield in ('d')) and source_id in (!!selected_sources!!)]]>

='!!p!!'*1) and (ufield='210' and usubfield in ('d')) and source_id in (!!selected_sources!!)]]>

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

value like '!!p!!%' or 0

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

0

entrepots value i_value recid

entrepots value i_value recid

entrepots value i_value recid

lang

lang

msg:4057 msg:4010 msg:articles_query

doctype

select orinot_id, orinot_nom from origine_notice

select id_notice_statut, gestion_libelle from notice_statut

select distinct recid as notice_id, date_import from entrepot_source_!!current_source!! where date_import='!!p!!' and source_id in (!!selected_sources!!)

select distinct recid as notice_id, date_import from entrepot_source_!!current_source!! where date_import<'!!p!!' and source_id in (!!selected_sources!!)

select distinct recid as notice_id, date_import from entrepot_source_!!current_source!! where date_import>'!!p!!' and source_id in (!!selected_sources!!)

select distinct recid as notice_id, date_import from entrepot_source_!!current_source!! where date_import<='!!p!!' and source_id in (!!selected_sources!!)

select distinct recid as notice_id, date_import from entrepot_source_!!current_source!! where date_import>='!!p!!' and source_id in (!!selected_sources!!)

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 idlocation,location_libelle from docs_location where location_visible_opac=1

0 -1 select surloc_id,surloc_libelle from sur_location where surloc_visible_opac=1 order by surloc_libelle

select idsection,section_libelle from docs_section where section_visible_opac=1 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

select idcode,codestat_libelle from docs_codestat

'!!p!!'*1) and (ufield='210' and usubfield in ('d')) and source_id in (!!selected_sources!!)]]>

='!!p!!'*1) and (ufield='210' and usubfield in ('d')) and source_id in (!!selected_sources!!)]]>

select notice_id, tit1 from notices where niveau_biblio='s' order by index_sew

select idlocation,location_libelle from docs_location order by location_libelle

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'

select idcaddie,name from caddie where type='EXPL'

select idcaddie,name from caddie where type='BULL'

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

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

msg:expr_bool_query msg:contient_search 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