1. Апдейт страниц у которых нет weight

cake daemon -q manual_update -t queue -o "weight_update (weight IS NULL) AND (free_places > 0) AND (ext_links <= 10) AND (sape_price <= 25) GROUP by domain_id ORDER by free_places ASC, ext_links ASC, sape_price ASC LIMIT 2000"
_____________________________________________________________________________________________________________________________________________________

2. Пробиваем Google Cache страниц у которых пробит weight

cake daemon -q manual_update -t queue -o "google_cache (weight > 0) AND (free_places > 0) AND (ext_links <= 10) GROUP by domain_id ORDER by weight ASC"

_____________________________________________________________________________________________________________________________________________________

3. Пробиваем все параметры для страниц, у которых есть недельный кеш

cake daemon -q manual_update -t queue -o "index_google (google_cache >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND ((index_google IS NULL) OR (last_update_index_google < DATE_SUB(NOW(), INTERVAL 7 DAY))) ORDER by index_google ASC, last_update_index_google ASC"

cake daemon -q manual_update -t queue -o "index_yandex (google_cache >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND ((index_yandex IS NULL) OR (last_update_index_yandex < DATE_SUB(NOW(), INTERVAL 10 DAY))) ORDER by index_yandex ASC, last_update_index_yandex ASC"

cake daemon -q manual_update -t queue -o "index_google_supplement (google_cache >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND ((snot IS NULL) OR (last_update_snot < DATE_SUB(NOW(), INTERVAL 10 DAY))) ORDER by snot ASC, last_update_snot ASC"

cake daemon -q manual_update -t queue -o "text_count (google_cache >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND ((text_symbols IS NULL) OR (last_update_text_symbols < DATE_SUB(NOW(), INTERVAL 30 DAY))) ORDER by text_symbols ASC, last_update_text_symbols ASC"

cake daemon -q manual_update -t queue -o "has_stopwords (google_cache >= DATE_SUB(NOW(), INTERVAL 7 DAY)) AND ((stopwords IS NULL) OR (last_update_stopwords < DATE_SUB(NOW(), INTERVAL 30 DAY))) ORDER by stopwords ASC, last_update_stopwords ASC"