SELECT `rep_id`, `rep_sub_cat_1_id`, `rep_url`, `rep_date` FROM `mr_report` WHERE `rep_status` = 'Y' AND `rep_archive_status` = 'N' AND `rep_url` = 'nano-coatings-market-3254'okk