SELECT @task_all := (SELECT COUNT(*) FROM task_manager WHERE tsm_group='default' ) AS task_all, @in_work := (SELECT COUNT(*) FROM task_manager WHERE tsm_status != 'COMPLETE' AND tsm_group='default' ) AS in_work, @complete := (SELECT COUNT(*) FROM task_manager WHERE tsm_status = 'COMPLETE' AND tsm_group='default') AS complete, CONCAT(REPEAT('#|',@complete),REPEAT('_|',@in_work)) AS c, ROUND(@complete / @task_all * 100) AS progress, (SELECT tsm_name FROM task_manager WHERE tsm_status <> 'COMPLETE' AND tsm_group='default' ORDER BY tsm_id LIMIT 1) AS task, (SELECT tsm_id FROM task_manager WHERE tsm_status <> 'COMPLETE' AND tsm_group='default' ORDER BY tsm_id LIMIT 1) AS task_id, (SELECT tsm_status FROM task_manager WHERE tsm_status <> 'COMPLETE' AND tsm_group='default' ORDER BY tsm_id LIMIT 1) AS task_status, (SELECT DATE_ADD(`date`, INTERVAL -2 HOUR) AS date_field FROM ar_ps_motors.__log ORDER BY `id` DESC LIMIT 1) AS last_activity