SELECT
	o.user_id,
	o4.id subject_id,
	o.created_at
FROM
(SELECT i.user_id, i.shixun_id, i.created_at FROM myshixuns i WHERE i.user_id IN (SELECT id FROM users WHERE TYPE = 'User' AND (last_login_on >= 'LAST_LOGIN_TIME'))) o
LEFT JOIN subject_shixun_infos o3 ON o.shixun_id = o3.shixun_id
LEFT JOIN subjects o4 ON o3.subject_id = o4.id
WHERE o4.hidden != 1 AND o4.status = 2 and (o.created_at >= 'LAST_CREATED_TIME');