SELECT site_id, site_code, site_title, site_url, site_desc, site_image, site_image_1068, site_status, site_file_name, designer_name, designer_email, designer_url, designer_image, site_year, site_dir, date_awarded, date_approved, DATE_FORMAT(date_awarded, '%%e') AS award_day, DATE_FORMAT(date_awarded, '%%b') AS award_month, DATE_FORMAT(date_awarded, '%%Y') AS award_year, DATE_FORMAT(date_approved, '%%e') AS approved_day, DATE_FORMAT(date_approved, '%%b') AS approved_month, DATE_FORMAT(date_approved, '%%Y') AS approved_year, color_id_1, color_id_2, color_id_3, style_id_1, style_id_2, style_id_3, industry_id, country_id, vote_deadline, time_format(timediff(vote_deadline,NOW()),'%%H:%%i:%%s') AS time_left, wotm, wotm_month, wotm_year, doty, doty_year, woty, woty_year FROM websites WHERE site_status = 'A' AND designer_name = '%s' AND date_awarded >= '2017-01-01' AND date_awarded <= '2017-12-31' ORDER BY date_approved DESC, site_id DESC Websites Designed By Resn ~ Featured On CSSDA
Go to Top