SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, manques.neuf, manques.nac, manques.nsg, manques.oblitere, manques.surlettre FROM france
LEFT JOIN manques ON france.dallay= manques.dallay and no_adherent = #session.NoMembre#
Where 0=0
and rubrique='#catid#' and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%') and france.dallay= '#trim(Catid)##Dallay#'
order by ordre
Update manques set neuf=#LNSC#, nac=#LNAC#, nsg=#LNSG#, oblitere=#LOblitere#, surlettre=#LSurlettre#
Where no_adherent=#Session.NoMembre# and dallay='#qTimbres2.dallay#'
Insert into manques (no_adherent, dallay, neuf, nac, nsg, oblitere, surlettre)
VALUES (#Session.NoMembre#, '#qTimbres2.dallay#', #LNSC#, #LNAC#, #LNSG#, #LOblitere#, #LSurlettre#)
Delete from manques where dallay='#Dallay#' and no_adherent = #session.NoMembre#
SELECT libellerubrique FROM rubriques
Where coderubrique='#catid#'
Philatélix
SELECT * FROM profils where nochrono=#Session.NoMembre#
SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, manques.neuf, manques.nac, manques.nsg, manques.oblitere, manques.surlettre ,
cotations2001.neuf as cot_nsc, cotations2001.neufaveccharniere as cot_nac, cotations2001.nsg as cot_nsg, cotations2001.oblitere as cot_obli, cotations2001.lettre as cot_surl
FROM cotations2001, france
LEFT JOIN manques ON france.dallay= manques.dallay and no_adherent = #session.NoMembre#
Where cotations2001.dallay=france.dallay
and rubrique='#catid#' and (designation like '%#Motcle#%' or designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or valeurfaciale like '%#Motcle#%' or couleurs like '%#Motcle#%') and france.dallay= '#trim(Catid)##Dallay#'
order by ordre