SELECT `p`.`ID`, `p`.`post_title`, `post_slug`, `p`.`post_excerpt`, `post_custom_author`, `p`.`post_image`, `p`.`post_thumbnail`, DATE_FORMAT( publish_date, "%d %M, %Y")as pubdate, DATE_FORMAT(`publish_date`, "%W %M %e, %Y") AS `publish_dates` FROM (`ucan_posts` p) WHERE `publish_date` <=NOW() AND `post_status` = 1 AND (`author_id` = 10 OR replace(p.post_custom_author, '.', '') LIKE CONVERT('%Stephan Uttom Rozario' USING latin1)) ORDER BY `publish_date` DESC LIMIT 12 OFFSET 12