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

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

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