select 
    userid,
    case NEAT
        when 6 then '<img src="http://www.yourmoodle.com/images/someimage.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as NEAT,
    case SCRATCH
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage1.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as SCRATCH,
    case SHARING
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage2.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as SHARING,
    case CHECKLIST
        when 4 then '<img src="http://www.yourmoodle.com/images/someimage3.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as CHECKLIST,
    case LEVELS
        when 4 then '<img src="http://www.yourmoodle.com/images/someimage4.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as LEVELS,
    case QUIZ_1
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage5.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as QUIZ_1,
    case QUIZ_2
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage6.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as QUIZ_2,
    case QUIZ_3
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage7.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as QUIZ_3,
    case TUTORIAL
        when 10 then '<img src="http://www.yourmoodle.com/images/someimage8.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as TUTORIAL,
    case WIZARD
        when 20 then '<img src="http://www.yourmoodle.com/images/someimage9.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as WIZARD,
    case VICTOR
        when 1 then '<img src="http://www.yourmoodle.com/images/someimage10.png" alt="Smiley face" height="20" width="20">'
        else '-'
    END as VICTOR
from
    (select 
        userid,
            sum(col14415) + sum(col14416) + sum(col14417) + sum(col14418)  + sum(col14419) + sum(col14420)  as NEAT,
            sum(col14413) as SCRATCH,
            sum(col14445) as SHARING,
            sum(col14455) + sum(col14462) + sum(col14478) + sum(col14484) as CHECKLIST,
            sum(col14456) + sum(col14464) + sum(col14479) + sum(col14485) as LEVELS,
            sum(col14448) as QUIZ_1,
            sum(col14450) as QUIZ_2,
            sum(col14453) as QUIZ_3,
            sum(col14444) + sum(col14463) + sum(col14471)  + sum(col14474) + sum(col14489)  + sum(col14490) + sum(col14491)  + sum(col14492) + sum(col14493) + sum(col14495) as TUTORIAL,
            sum(col14510) + sum(col14511) + sum(col14512)  + sum(col14513) + sum(col14514)  + sum(col14515) + sum(col14516)  + sum(col14517) + sum(col14418) + sum(col14519) + sum(col14520) + sum(col14521) + sum(col14522)  + sum(col14523) + sum(col14524)  + sum(col14525) + sum(col14526)  + sum(col14527) + sum(col14528) + sum(col14529) as WIZARD,
            sum(col14501) as VICTOR
    from
        (SELECT 
        userid,
            case coursemoduleid
                when 14413 then 1
                else 0
            end as col14413,
            case coursemoduleid
                when 14415 then 1
                else 0
            end as col14415,
            case coursemoduleid
                when 14416 then 1
                else 0
            end as col14416,
            case coursemoduleid
                when 14417 then 1
                else 0
            end as col14417,
            case coursemoduleid
                when 14418 then 1
                else 0
            end as col14418,
            case coursemoduleid
                when 14419 then 1
                else 0
            end as col14419,
            case coursemoduleid
                when 14420 then 1
                else 0
            end as col14420,
            case coursemoduleid
                when 14421 then 1
                else 0
            end as col14421,
            case coursemoduleid
                when 14422 then 1
                else 0
            end as col14422,
            case coursemoduleid
                when 14423 then 1
                else 0
            end as col14423,
            case coursemoduleid
                when 14424 then 1
                else 0
            end as col14424,
            case coursemoduleid
                when 14444 then 1
                else 0
            end as col14444,
            case coursemoduleid
                when 14445 then 1
                else 0
            end as col14445,
            case coursemoduleid
                when 14448 then 1
                else 0
            end as col14448,
            case coursemoduleid
                when 14450 then 1
                else 0
            end as col14450,
            case coursemoduleid
                when 14453 then 1
                else 0
            end as col14453,
            case coursemoduleid
                when 14455 then 1
                else 0
            end as col14455,
            case coursemoduleid
                when 14456 then 1
                else 0
            end as col14456,
            case coursemoduleid
                when 14462 then 1
                else 0
            end as col14462,
            case coursemoduleid
                when 14463 then 1
                else 0
            end as col14463,
            case coursemoduleid
                when 14464 then 1
                else 0
            end as col14464,
            case coursemoduleid
                when 14471 then 1
                else 0
            end as col14471,
            case coursemoduleid
                when 14474 then 1
                else 0
            end as col14474,
            case coursemoduleid
                when 14478 then 1
                else 0
            end as col14478,
            case coursemoduleid
                when 14479 then 1
                else 0
            end as col14479,
            case coursemoduleid
                when 14484 then 1
                else 0
            end as col14484,
            case coursemoduleid
                when 14485 then 1
                else 0
            end as col14485,
            case coursemoduleid
                when 14489 then 1
                else 0
            end as col14489,
            case coursemoduleid
                when 14490 then 1
                else 0
            end as col14490,
            case coursemoduleid
                when 14491 then 1
                else 0
            end as col14491,
            case coursemoduleid
                when 14492 then 1
                else 0
            end as col14492,
            case coursemoduleid
                when 14493 then 1
                else 0
            end as col14493,
            case coursemoduleid
                when 14495 then 1
                else 0
            end as col14495, 
            case coursemoduleid
                when 14501 then 1
                else 0
            end as col14501,
            case coursemoduleid
                when 14510 then 1
                else 0		
            end as col14510,	
            case coursemoduleid		
                when 14511 then 1
                else 0		
            end as col14511,	
            case coursemoduleid		
                when 14512 then 1
                else 0		
            end as col14512,	
            case coursemoduleid		
                when 14513 then 1
                else 0		
            end as col14513,	
            case coursemoduleid		
                when 14514 then 1
                else 0		
            end as col14514,	
            case coursemoduleid		
                when 14515 then 1
                else 0		
            end as col14515,	
            case coursemoduleid		
                when 14516 then 1
                else 0		
            end as col14516,	
            case coursemoduleid		
                when 14517 then 1
                else 0		
            end as col14517,	
            case coursemoduleid		
                when 14518 then 1
                else 0		
            end as col14518,	
            case coursemoduleid		
                when 14519 then 1
                else 0		
            end as col14519,	
            case coursemoduleid		
                when 14520 then 1
                else 0		
            end as col14520,	
            case coursemoduleid		
                when 14521 then 1
                else 0		
            end as col14521,	
            case coursemoduleid		
                when 14522 then 1
                else 0		
            end as col14522,	
            case coursemoduleid		
                when 14523 then 1
                else 0		
            end as col14523,	
            case coursemoduleid		
                when 14524 then 1
                else 0		
            end as col14524,	
            case coursemoduleid		
                when 14525 then 1
                else 0		
            end as col14525,	
            case coursemoduleid		
                when 14526 then 1
                else 0		
            end as col14526,	
            case coursemoduleid		
                when 14527 then 1
                else 0		
            end as col14527,	
            case coursemoduleid		
                when 14528 then 1
                else 0		
            end as col14528,	
            case coursemoduleid		
                when 14529 then 1
                else 0		
            end as col14529	

    FROM
        prefix_course_modules_completion
    where
        completionstate = 1
    group by userid , coursemoduleid) t
    GROUP BY userid) t2
where
    (userid in (1012 , 1013) or (userid >= 1223 and userid <= 1243))
order by userid asc