כותרים חדשים

SELECT sefer.shem, sefer.mehaber, sefer.numsidra, sefer.teur, tsidra.shem AS sidra, tmikum.shem AS mikum FROM sefer LEFT JOIN tsidra ON sefer.sidra = tsidra.semel LEFT JOIN otek ON sefer.semel = otek.sefer LEFT JOIN tmikum ON otek.mikum = tmikum.semel WHERE sefer.kitdate >= ':תאריךהתחלה' AND sefer.kitdate <= ':תאריךסיום' AND otek.otek = 1 ORDER BY sefer.meyuad