sql? order by an inner join?

[n8w]

Can someone please tell me how I can take this exact where but order it by the table.field

"favorites.added_date"

 

if($peoplelike){
$sql='SELECT a.* , c.*, d.*, l.printable_name,l.numcode
FROM illustrators_table a
INNER JOIN users d ON a.user_id = d.user_id
LEFT JOIN country l ON d.country_id = l.numcode
INNER JOIN (SELECT * from favorites where illustrator_id = "'.$peoplelike.'" GROUP BY user_id) c ON a.user_id = c.user_id
WHERE visible = "t" && s_verified = "t" ORDER BY a.count_clicks ASC ';
$sql_pagination = $sql;
$sql = $sql. ' LIMIT ' . $offset . ',' . $page_limit;
}

 

I tried the following but it gives me the error unknown table

WHERE visible = "t" && s_verified = "t" ORDER BY favorites.add_date ASC ';

 

Thanks!!!!!

 

 

[gevans]

favorites is used on the subquery and is not referenced in the main query so cannot be used in the main where claue or order by clause.