1. SQL / Говнокод #677

    −856.5

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    select sum(all_.allscores) as allscores, sum(all_.matched) as matched, all_.id, all_.title, cc.name, cc.id as cmpId 
from 
	(select SE.assid as id, SE.allcurrent as allscores, SE.matched, SE.title-- SE.name -- ,SE.title,SE.cmpId
	FROM
	(select allb.assid, sum(allb.allcurrent) as allcurrent, sum(allb.match_cnt) as matched, allb.title -- ,cc.name,cc.id as cmpId, -- , aa.id 
	from 
		(select * from
			(SELECT assa.title, IFNULL(allcur.allcurrent,0) as allcurrent, assa.id as assid , IFNULL(SUM( res.weight),0) AS match_cnt 
			   FROM 
				ass_assignment assa LEFT JOIN 
				(SELECT  DISTINCT pss.cv_i
....

    ёбаные лесенки...

    Запостил: guest, 06 Марта 2009

    Комментарии (1) RSS

    • ava guest 06.03.2009 14:01 # 0

      О боже...
      Особенно улыбнуло
      [quote]SE.title-- SE.name --,SE.title,SE.cmpId[/quote]
      Комменты как замена SVN?
      Ответить

    Добавить комментарий