Home

My Library

Log In

Sign Up

SELECT b2s.book AS book, 1 AS prioritycol FROM book2subjects AS b2s INNER JOIN sub_subject AS ss ON ss.id = b2s.sub_subject WHERE ss.id = 19 UNION SELECT b2s.book AS book, 2 AS prioritycol FROM book2subjects AS b2s INNER JOIN sub_sub_subject AS sss ON sss.id = b2s.sub_sub_subject INNER JOIN sub_subject AS ss ON ss.id = sss.sub_subject WHERE ss.id = 19 ORDER BY prioritycol, RAND() LIMIT 12