SQL Query Error (
            SELECT
                i.*,
                LEFT(i.description,200) AS description_,
                istat.name AS status ,
                im.filename AS filename,
                it.name as item_type,
                ie.name as iesrb,
                s.name as studio,
                if (count_in_store>0, 'On Hand', 'Checked Out') as enabled,
                if (running_time>0, concat(running_time, ' minutes'), 'Unknown') as running_time_text
            FROM
                items AS i,
                item_statuses AS istat,
                item_types as it
                
                
            LEFT JOIN images im ON (im.id = i.ref_image )
            LEFT JOIN studios s ON (s.id = i.ref_studio )
            LEFT JOIN item_esrbs ie ON (ie.id=i.ref_item_esrb)
            WHERE istat.id = i.ref_item_status
            AND it.id=i.ref_item_type
            
            
            
            
           AND  TO_DAYS(NOW()) - TO_DAYS(i.release_date) >= 0
                     AND  TO_DAYS(NOW()) - TO_DAYS(i.release_date) <= 30 GROUP BY i.name ORDER BY i.release_date  desc, i.id LIMIT 0, 4) : Unknown column 'i.ref_image' in 'on clause'