SELECT SQL_CALC_FOUND_ROWS *, (STR_TO_DATE(desc2, '%Y-%m-%d')) as eventDate FROM aff_prods WHERE substr(ex5,-2,1) > 0 and imgpath not like '%nocover.jpg' and prod_type = 'Comics' and brand <> '' and retail > 0 and code = 8908 and (STR_TO_DATE(desc2, '%Y-%m-%d')) >= DATE_ADD(CURDATE(),INTERVAL -7 DAY) and (STR_TO_DATE(desc2, '%Y-%m-%d')) <= DATE_ADD(CURDATE(),INTERVAL 7 DAY) order by brand, prod_name asc LIMIT 0, 100