Displaying 1 result from an estimated 1 matches for "number_days".
2008 Dec 06
1
find with add of an atttributes
...es]},{:place=>:location}],
:joins =>" RIGHT JOIN (SELECT
event_dates.id,date_add(event_dates.date, INTERVAL i DAY ) AS date
FROM (select 0 as i union all select 0 union all select 1
union all select 2) as integers CROSS JOIN event_dates
WHERE i<= number_days AND (event_dates.days_of_week=''8''
OR concat(''%'',event_dates.days_of_week,''%'') like
concat(''%'',DATE_FORMAT(date_add( event_dates.date, INTERVAL i DAY
),''%w''),''%''))
ORDER BY da...