как сделать выборку за 90 дней, если дата храниться в timespamp?
SELECT `modx_site_content`.id, pagetitle,article, image, content, alias, vendor, size, price FROM `modx_site_content` left join `modx_ms2_products` on `modx_ms2_products`.id = `modx_site_content`.id where `modx_site_content`.parent = 56 and `modx_site_content`.`template` = 31 and `context_key`='web' AND `modx_ms2_products`.price between 0 and 3000 and `modx_site_content`.createdon < DATE_SUB(CURRENT_DATE, INTERVAL 91 DAY)