SELECT b.*, b.image as bresim, b.title as btitle from books b
join books_types bt on bt.bid=b.id
where bt.tid in
(
select distinct(bt.tid) from users_books u
join books b on b.id = u.bid
join books_types bt on bt.bid = b.id
where u.uid = $sessionid and (u.liblary = '1' or u.liked = '1')
)
ORDER BY RAND()
      LIMIT 8