это:
Code: Select all
sql_query_pre = UPDATE rot_settings SET value = (SELECT MAX(gallery_id) FROM rot_gallery_info WHERE gallery_status = 'active' and activation_date <= NOW()) WHERE name = 'sphinx_max_gallery_id'
Code: Select all
sql_query_pre = UPDATE rot_settings SET value = (SELECT MAX(gallery_id) FROM rot_gallery_info) WHERE name = 'sphinx_max_gallery_id'
не понял только, на каком этапе туда записалось 40107 документов.