SELECT `mediaon_announces_announces`.`id`, `mediaon_announces_announces`.`category_id`,
`mediaon_announces_announces`.`province_id`, `mediaon_announces_announces`.`city_id`,
`mediaon_announces_announces`.`hamlet_id`, `mediaon_announces_announces`.`address`,
`mediaon_announces_announces`.`sender_id`, `mediaon_announces_announces`.`created`,
`mediaon_announces_announces`.`updated`, `mediaon_announces_announces`.`pub_date`,
`mediaon_announces_announces`.`title`, `mediaon_announces_announces`.`text`, `mediaon_announces_announces`.`is_private`,
`mediaon_announces_announces`.`moderated`, `mediaon_announces_announces`.`is_publishable`,
`mediaon_announces_announces`.`pubblished`, `mediaon_announces_announces`.`deleted`,
`mediaon_announces_announces`.`auto_publish`, `mediaon_announces_announces`.`email`,
`mediaon_announces_announces`.`under_age` FROM `mediaon_announces_announces` INNER JOIN
`mediaon_announces_announces_site` ON (`mediaon_announces_announces`.`id` =
`mediaon_announces_announces_site`.`announces_id`) WHERE (`mediaon_announces_announces`.`deleted` = False AND
`mediaon_announces_announces`.`auto_publish` = False AND `mediaon_announces_announces_site`.`site_id` = 17 AND
`mediaon_announces_announces`.`moderated` = False AND `mediaon_announces_announces`.`pub_date` BETWEEN 2018-10-23 and
2019-02-20 AND `mediaon_announces_announces`.`is_private` = False AND `mediaon_announces_announces`.`pub_date` =
2018-09-18 ) ORDER BY `mediaon_announces_announces`.`pub_date` DESC, `mediaon_announces_announces`.`created` DESC