SELECT DISTINCT anketa.id, anketa.noid, anketa.name, anketa.gorod, anketa.vozrast, anketa.partid, anketa.active, if (anketa.provereno = 'yes' AND anketa.urovid=2,1.5,anketa.urovid) as urov, sin(anketa.id*505) as rn, no.no, no.active as noactive, no.id as nid FROM (anketa,users,no) INNER JOIN anketa_index ON anketa_index.itemid=anketa.id AND anketa_index.place = 'anketa' WHERE anketa.noid=no.id AND anketa.userid = users.id AND anketa.idsite = 0 AND (anketa.active ='yes' ) AND users.active='yes' AND anketa.active ='yes' AND users.active='yes' AND (anketa.vozrast > 0) AND (anketa.rost > 0) AND (anketa.ves >= 0) AND (anketa.grud >= 0) AND (anketa.odezhda >= 0) AND anketa.regionid='48' AND ( (anketa_index.txt LIKE 'водн%' OR anketa_index.txt LIKE '% водн%') AND (anketa_index.txt LIKE 'стадион%' OR anketa_index.txt LIKE '% стадион%') ) ORDER BY relevance DESC, urov ASC, rn ASC
MySQL Error: Unknown column 'relevance' in 'order clause'
This script cannot continue, terminating.