Есть запрос
("SELECT actions. * , image_f_big, actions_city.title AS city
FROM actions LEFT JOIN actions_img ON actions.id = actions_img.action_id
LEFT JOIN actions_city ON actions_city.id = actions.city_id
WHERE actions.end_date>=Now() AND actions.status=3
GROUP BY actions.id ORDER BY action_id DESC ");
При обращении выдает следующую ошибку
MySQL error: Column 'action_id' in order clause is ambiguous<br>SELECT actions. * , image_f_big, actions_city.title AS city<br />
FROM actions LEFT JOIN actions_img ON actions.id = actions_img.action_id<br />
LEFT JOIN actions_city ON actions_city.id = actions.city_id<br />
WHERE actions.end_date>=Now() AND actions.status=3<br />
GROUP BY actions.id ORDER BY action_id DESC
Прошу подсказать в чем дело!