daa

SELECT t1.`link_href` FROM `linkbuilding_registry` as t1 INNER JOIN `linkbuilding_sites` as t2 ON t1.site_id=t2.id INNER JOIN `linkchecker_registry` as t3 ON t1.`id` = t3.`linkbuilding_registry_id` WHERE DATE_FORMAT(t3.`updated_at`, '%Y-%m-%d') = DATE_FORMAT(SUBDATE(NOW(), 1), '%Y-%m-%d') AND t3.`status` = 2 AND t2.`project_id` = 3 ORDER BY RAND() LIMIT 150