select

register_session_year,
register_session_week,
register_sessions.team_id,

CONCAT_WS(‘-’,
register_session_year,
register_session_week,
register_sessions.team_id
) AS tyw,

sum(case when register_session_code= ‘i’ then 1 else 0 end)/10 as uin,
sum(case when register_session_code= ‘h’ then 1 else 0 end)/10 as uh,
sum(case when register_session_code= ‘s’ then 1 else 0 end)/10 as us,
sum(case when register_session_code= ‘l’ then 1 else 0 end)/10 as ul,
sum(case when register_session_code= ‘aa’ then 1 else 0 end)/10 as uaa,
sum(case when register_session_code= ‘ua’ then 1 else 0 end)/10 as ua,
sum(case when register_session_code= ‘dp’ then 1 else 0 end)/10 as udp,
sum(case when register_session_code= ‘mp’ then 1 else 0 end)/10 as ump,
sum(case when register_session_code= ‘pn’ then 1 else 0 end)/10 as upn,
sum(case when register_session_code= ‘nos’ then 1 else 0 end)/10 as unos,
sum(case when register_session_code= ‘pa’ then 1 else 0 end)/10 as upa
– sum(case when users_sale_islive= ’1′ then 1 else 0 end)/10 as salelive,
– sum(case when users_sale_islive= ’0′ then 1 else 0 end)/10 as salenotlive
FROM users,register_sessions
WHERE
register_sessions.user_id = users.user_id
AND (
( register_session_year >= 2008 AND register_session_week >= 14 )
|| ( register_session_year = 2009 AND register_session_week < 14 ) ) AND register_sessions.team_id IN (“.$teamslist.”) AND DATE_FORMAT(user_creation_date,’%Y-%V’) != CONCAT_WS(‘-’,register_session_year,register_session_week) GROUP BY tyw ORDER BY register_sessions.team_id, register_session_year, register_session_week