Закрыть

Есть предложение, вопрос или нашли ошибку?
Напишите нам!

SELECT m.mfo_regnum mfo_regnum_new, z.id zaim_id, z.free_zaim, 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.id, 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.city_all_crapp FROM (SELECT b.mfo_regnum FROM mfo_branches b WHERE b.city="Москва" UNION SELECT a.mfo_regnum FROM crapp a, cityadv ca WHERE NOT a.mfo_regnum = "" AND a.activ="1" AND a.id = ca.advid AND (ca.cityname="Москва" OR ca.cityname="*")) m, mfo_zaym z, mfo LEFT JOIN ( SELECT a.*, ca.cityname city_all_crapp FROM crapp a, cityadv ca WHERE NOT a.mfo_regnum = "" AND a.activ="1" AND a.mfo_regnum != "" AND a.id = ca.advid AND (ca.cityname="Москва" OR ca.cityname="*")) c ON c.mfo_regnum = mfo.mfo_regnum WHERE mfo.mfo_regnum = m.mfo_regnum AND mfo.mfo_regnum = z.mfo_regnum AND mfo.data_iskl = "" AND z.ur = "0" AND z.repeated = "0" AND mfo.mfo_regnum != "001603045007582" AND c.mfo_regnum != "" GROUP BY z.mfo_regnum ORDER BY ABS(30000-z.max_sum), IF(c.priority IS NULL,1,0), c.priority, if(z.`max_proc`,1,2),(z.`min_proc`+z.`max_proc` + (c.priority/20)) ASC,if(z.`min_proc`,1,2),z.`max_proc` ASC LIMIT 3