SELECT event.*
FROM   event
       INNER JOIN event_date
         ON event.id = event_date.event_id
WHERE  ( ( IF(MONTH(event_date.date_start) = 1
              AND Weekofyear(event_date.date_start) = Weekofyear("2012-12-31"),
           1,
                      Weekofyear(event_date.date_start)) BETWEEN IF(MONTH(
                      event_date.date_start) = 1
                                                                    AND
                      Weekofyear(Str_to_date('01,1,2012', '%d,%m,%Y')) =
                      Weekofyear("2012-12-31"), 1, Weekofyear(Str_to_date(
                                                              '01,1,2012',
                                                              '%d,%m,%Y'))) AND
                      Weekofyear(Last_day(Str_to_date('01,1,2012', '%d,%m,%Y')))
           AND YEAR(event_date.date_start) = 2012 )
          OR (
IF(MONTH(event_date.date_end) = 1
   AND Weekofyear(event_date.date_end) = Weekofyear("2012-12-31"), 1,
      Weekofyear(event_date.date_end)) BETWEEN
      IF(MONTH(event_date.date_end) = 1
         AND Weekofyear(Str_to_date(
                        '01,1,2012',
                        '%d,%m,%Y')) =
             Weekofyear("2012-12-31"), 1, Weekofyear(Str_to_date(
                                                     '01,1,2012',
                                                     '%d,%m,%Y'))) AND
      Weekofyear(Last_day(Str_to_date('01,1,2012', '%d,%m,%Y')))
AND YEAR(event_date.date_end) = 2012 ) )
       AND event.publish_date <= NOW()
GROUP  BY event.id
ORDER  BY event_date.date_start ASC,
          ( event_date.date_start = Curdate() ) DESC