Need to Optimize this Query
Database
1
Posts
1
Posters
0
Views
1
Watching
-
How to optimize this query. SELECT share_id, page_id, parent_title, title, share_type, shared_on, IF(FIND_IN_SET('".$_POST["student_id"]."_Y', students), 'Y', 'N') AS is_viewed FROM dash_sharing WHERE book_id = :book_id AND ( FIND_IN_SET('".$_POST["student_id"]."_N', students) OR FIND_IN_SET('".$_POST["student_id"]."_Y', students)) AND (page_id, shared_on) IN (SELECT page_id, MAX(shared_on) FROM dash_sharing AS mtab WHERE book_id = :book_id AND ( FIND_IN_SET('".$_POST["student_id"]."_N', students) OR FIND_IN_SET('".$_POST["student_id"]."_Y', students)) GROUP BY page_id) ORDER BY FIELD(is_viewed, 'N','Y') ASC, shared_on DESC