ruttindungquan6

UPDATE tasks
JOIN (
SELECT t.id
FROM tasks t
JOIN request r ON t.id_request = r.id
WHERE (t.status = 'new' OR t.status = 'connect')
AND t.id_tool = ""
AND t.site IN ([[AVAILABLE_SITES]])
ORDER BY r.auction_price DESC, t.id
LIMIT [[IDOL_THREAD_NUMBER]]
) AS limited_tasks ON tasks.id = limited_tasks.id
JOIN request r ON tasks.id_request = r.id
SET tasks.id_tool = {{Tool ID}}
WHERE r.id_tool = "";