daa

SELECT link_href FROM linkbuilding_registry JOIN linkbuilding_sites ON linkbuilding_registry.site_id = linkbuilding_sites.id JOIN linkchecker_registry ON linkbuilding_registry.id = linkchecker_registry.linkbuilding_registry_id WHERE DATE_FORMAT(linkchecker_registry.updated_at, '2018-02-01') = DATE_FORMAT(SUBDATE(NOW(), 1), '2018-02-28') AND linkchecker_registry.status = 2 ORDER BY RAND() LIMIT 300