Быстрые займы не выходя из дома с доставкой без отказа

SELECT c.mfo_regnum mfo_regnum_new, z.id zaim_id, z.mfo_regnum, z.name, z.latname latnamezaim, z.org, z.min_sum, z.max_sum, z.min_proc, z.max_proc, z.min_age, z.max_age, z.p_type, z.minP, z.maxP, z.minPD, z.maxPD, z.delivery, z.inScore, z.zalog, z.poruchitel, z.resource, z.info, z.m_type, z.maxM, z.r_type, z.maxR, z.repeated, z.inScore_card, mfo.mfo_regnum, mfo.data_zan, mfo.data_iskl, mfo.numb_svd, mfo.numb_gos, mfo.name_pol, mfo.name_kor, mfo.adres, mfo.latitude, mfo.longitude, mfo.fio, mfo.logo, mfo.brand_name, mfo.phone, mfo.url, mfo.logo_id, mfo.latname, c.id, c.parentID, c.bnkregnum, c.mfo_regnum, c.url, c.advtext, c.advname, c.advtextshort, c.advtype, c.proc, c.crlimit, c.grace, c.age, c.period, c.crlogo, c.pagetitle, c.pagetext, c.priority, c.activ, c.update, z.inMoneytransfer, z.inCash, z.qiwi, z.yandexmoney, d.adr_mfo_brnch, d.count_otd, d.latname_mfo_brnch, c.promotext, c.new FROM ( SELECT a.* FROM crapp a, ( SELECT ca.advid, '1' cnt FROM `cityadv` ca WHERE ca.cityname='*' UNION SELECT ca.advid, count(1) cnt FROM `cityadv` ca WHERE 1=1 GROUP BY advid HAVING cnt BETWEEN 100 AND 500 OR cnt>=700) ca WHERE NOT a.mfo_regnum = '' AND a.activ='1' AND a.id = ca.advid ) c, mfo_zaym z, mfo LEFT JOIN (SELECT adr adr_mfo_brnch, latname_adr latname_mfo_brnch, mfo_regnum, @q:=(SELECT COUNT(id) FROM mfo_branches WHERE `city`='' AND mfo_regnum=mfoo.mfo_regnum) count_otd FROM `mfo_branches` mfoo WHERE `city`='') d ON mfo.mfo_regnum=d.mfo_regnum WHERE c.mfo_regnum = mfo.mfo_regnum AND mfo.mfo_regnum = c.mfo_regnum AND mfo.mfo_regnum = z.mfo_regnum AND mfo.data_iskl = '' AND z.min_sum<50000 AND z.ur = '0' AND z.repeated = '0' AND z.delivery=1 AND z.repeated=0 AND c.mfo_regnum != '' GROUP BY z.id ORDER BY IF(c.priority IS NULL,1,0), if(z.`max_proc`,1,2),(z.`min_proc`+z.`max_proc` + (c.priority/5)) ASC,if(z.`min_proc`,1,2),z.`max_proc` ASC