Sort abortedselect * from v2_membre where 1 and ( nonm = '0' or nonm='1' or nonm is NULL or nonm = '3' or nonm = '4' ) and ctype LIKE "%presta%" and (ville LIKE "orleans %" or cp like '45%' OR depart like "45,%" OR depart like "%,45" OR depart like "%,45,%") and ( 0 or IDService like '%,37,%' or IDService like '37,%' or IDService like '%,37' or IDService='37' or IDService like '%,38,%' or IDService like '38,%' or IDService like '%,38' or IDService='38' or IDService like '%,39,%' or IDService like '39,%' or IDService like '%,39' or IDService='39' or IDService like '%,40,%' or IDService like '40,%' or IDService like '%,40' or IDService='40' or IDService like '%,41,%' or IDService like '41,%' or IDService like '%,41' or IDService='41' or IDService like '%,42,%' or IDService like '42,%' or IDService like '%,42' or IDService='42' or IDService like '%,43,%' or IDService like '43,%' or IDService like '%,43' or IDService='43' or IDService like '%,44,%' or IDService like '44,%' or IDService like '%,44' or IDService='44' or IDService like '%,364,%' or IDService like '364,%' or IDService like '%,364' or IDService='364' or IDService like '%,409,%' or IDService like '409,%' or IDService like '%,409' or IDService='409' or IDService like '%,410,%' or IDService like '410,%' or IDService like '%,410' or IDService='410' or IDService like '%,411,%' or IDService like '411,%' or IDService like '%,411' or IDService='411' or IDService like '%,412,%' or IDService like '412,%' or IDService like '%,412' or IDService='412' or IDService like '%,413,%' or IDService like '413,%' or IDService like '%,413' or IDService='413' or IDService like '%,414,%' or IDService like '414,%' or IDService like '%,414' or IDService='414' or IDService like '%,415,%' or IDService like '415,%' or IDService like '%,415' or IDService='415' or IDService like '%,4,%' or IDService like '4,%' or IDService like '%,4' or IDService='4' ) ORDER BY field( nonm, 'NULL' ,0 ) desc ,field(cp,'45000') desc,field(IDService,'') desc,hits DESC LIMIT 0,5 |