הצגת ספרים להמלצה

SELECT sefer.shem, sefer.Mehaber, sefer.semel, tyiud.shem AS yiud, (SELECT COUNT(semel) FROM otek WHERE otek.sefer = sefer.semel) AS num_otek, (SELECT COUNT(semel) FROM hashala WHERE hashala.sefer =sefer.semel) AS numh FROM sefer LEFT JOIN tyiud ON sefer.meyuad = tyiud.semel WHERE (SELECT COUNT(semel) FROM otek WHERE otek.sefer = sefer.semel) >= :עותקים AND SEFER.KITDATE < (GETDATE() - :ימים) ORDER BY numh asc