SQL: [2410] SELECT DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL seq.day_offset DAY), '%Y-%m-%d') AS next_session_date, last_slot.stime AS session_time, last_slot.sday, last_slot.id as slot_id FROM ( SELECT ts.sday, ts.stime, ts.id FROM training_slots ts WHERE ts.train_id = :tid ORDER BY STR_TO_DATE(ts.sdate, '%Y-%m-%d') DESC LIMIT 1 ) AS last_slot JOIN trainings t ON t.id = :tid JOIN ( SELECT 0 AS day_offset UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10 UNION SELECT 11 UNION SELECT 12 UNION SELECT 13 UNION SELECT 14 UNION SELECT 15 UNION SELECT 16 UNION SELECT 17 UNION SELECT 18 UNION SELECT 19 UNION SELECT 20 UNION SELECT 21 UNION SELECT 22 UNION SELECT 23 UNION SELECT 24 UNION SELECT 25 UNION SELECT 26 UNION SELECT 27 UNION SELECT 28 ) AS seq WHERE DAYNAME(DATE_ADD(CURDATE(), INTERVAL seq.day_offset DAY)) = CASE last_slot.sday WHEN 'Sun' THEN 'Sunday' WHEN 'Mon' THEN 'Monday' WHEN 'Tue' THEN 'Tuesday' WHEN 'Wed' THEN 'Wednesday' WHEN 'Thu' THEN 'Thursday' WHEN 'Fri' THEN 'Friday' WHEN 'Sat' THEN 'Saturday' END ORDER BY next_session_date; Sent SQL: [2410] SELECT DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL seq.day_offset DAY), '%Y-%m-%d') AS next_session_date, last_slot.stime AS session_time, last_slot.sday, last_slot.id as slot_id FROM ( SELECT ts.sday, ts.stime, ts.id FROM training_slots ts WHERE ts.train_id = '12' ORDER BY STR_TO_DATE(ts.sdate, '%Y-%m-%d') DESC LIMIT 1 ) AS last_slot JOIN trainings t ON t.id = '12' JOIN ( SELECT 0 AS day_offset UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10 UNION SELECT 11 UNION SELECT 12 UNION SELECT 13 UNION SELECT 14 UNION SELECT 15 UNION SELECT 16 UNION SELECT 17 UNION SELECT 18 UNION SELECT 19 UNION SELECT 20 UNION SELECT 21 UNION SELECT 22 UNION SELECT 23 UNION SELECT 24 UNION SELECT 25 UNION SELECT 26 UNION SELECT 27 UNION SELECT 28 ) AS seq WHERE DAYNAME(DATE_ADD(CURDATE(), INTERVAL seq.day_offset DAY)) = CASE last_slot.sday WHEN 'Sun' THEN 'Sunday' WHEN 'Mon' THEN 'Monday' WHEN 'Tue' THEN 'Tuesday' WHEN 'Wed' THEN 'Wednesday' WHEN 'Thu' THEN 'Thursday' WHEN 'Fri' THEN 'Friday' WHEN 'Sat' THEN 'Saturday' END ORDER BY next_session_date; Params: 1 Key: Name: [4] :tid paramno=-1 name=[4] ":tid" is_param=1 param_type=2