SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-1" AND endrepeat >= "2012-01-1"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-2" AND endrepeat >= "2012-01-2"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-3" AND endrepeat >= "2012-01-3"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-4" AND endrepeat >= "2012-01-4"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-5" AND endrepeat >= "2012-01-5"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-6" AND endrepeat >= "2012-01-6"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-7" AND endrepeat >= "2012-01-7"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-8" AND endrepeat >= "2012-01-8"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-9" AND endrepeat >= "2012-01-9"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-10" AND endrepeat >= "2012-01-10"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-11" AND endrepeat >= "2012-01-11"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-13" AND endrepeat >= "2012-01-13"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-14" AND endrepeat >= "2012-01-14"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-15" AND endrepeat >= "2012-01-15"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-17" AND endrepeat >= "2012-01-17"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-18" AND endrepeat >= "2012-01-18"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-19" AND endrepeat >= "2012-01-19"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-20" AND endrepeat >= "2012-01-20"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-21" AND endrepeat >= "2012-01-21"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-22" AND endrepeat >= "2012-01-22"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-23" AND endrepeat >= "2012-01-23"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-25" AND endrepeat >= "2012-01-25"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-26" AND endrepeat >= "2012-01-26"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-27" AND endrepeat >= "2012-01-27"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-28" AND endrepeat >= "2012-01-28"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-29" AND endrepeat >= "2012-01-29"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-30" AND endrepeat >= "2012-01-30"
SELECT eventid FROM jos_jevents_repetition where startrepeat <= "2012-01-31" AND endrepeat >= "2012-01-31"