SELECT dallay, designationcourt, imagelargeur FROM france
where left(dallay,1) < 'A'
and anneeemission
between '1849' and '1899'
between '1900' and '1919'
between '1920' and '1929'
between '1930' and '1939'
= '#Annee#' and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%')
order by ordre
