>>>>> Anton writes:
Anton> explain analyze SELECT collect_time FROM n_traffic, n_logins
Anton> WHERE collect_time > '1970-01-01 00:00:00' AND
Anton> n_traffic.login_id = n_logins.login_id AND account_id = '1655'
Anton> ORDER BY collect_time LIMIT 1
А если таки явно нарисовать join ?
SELECT n_traffic.collect_time
FROM n_logins
JOIN n_traffic ON (n_traffic.login_id = n_logins.login_id AND
n_traffic.collect_time > '1970-01-01 00:00:00')
WHERE n_logins.account_id = '1655'
ORDER BY n_traffic.collect_time, n_traffic.login_id LIMIT 1
--
Sergey Suleymanov