SELECT p2.ID AS 'classID', p.post_title AS 'date', ch.*, p2.post_title AS 'title', (SELECT pi.post_title FROM wp_12_posts pi WHERE pi.ID = ch.trainers) AS 'trainer', (SELECT pi2.ID FROM wp_12_posts pi2 WHERE pi2.ID = ch.trainers) AS 'trainerID', CASE WHEN p.post_title like '%Tuesday%' THEN 1 WHEN p.post_title like '%Wednesday%' THEN 2 WHEN p.post_title like '%Thursday%' THEN 3 WHEN p.post_title like '%Friday%' THEN 4 WHEN p.post_title like '%Saturday%' THEN 5 WHEN p.post_title like '%Sunday%' THEN 6 WHEN p.post_title like '%Monday%' THEN 7 ELSE 8 END AS 'sortedby_weekday', CASE WHEN p.post_title LIKE 'Sunday%' then 1 WHEN p.post_title LIKE 'Monday%' then 2 WHEN p.post_title LIKE 'Tuesday%' then 3 WHEN p.post_title LIKE 'Wednesday%' then 4 WHEN p.post_title LIKE 'Thursday%' then 5 WHEN p.post_title LIKE 'Friday%' then 6 WHEN p.post_title LIKE 'Saturday%' then 7 ELSE 8 END AS 'php_weekday' FROM wp_12_posts p INNER JOIN wp_12_class_hours ch ON ch.weekday_id = p.ID INNER JOIN wp_12_posts p2 ON p2.ID = ch.class_id WHERE p.post_title LIKE '%Tuesday%' ORDER BY `sortedby_weekday`, ch.start