Re: Count in where clause only id's from 2 tables

[Hassan Yigit]

Yessss... I have it...

Thanks Peter for the first advice!

$searchrestaurant = "
SELECT restaurants.*, avg(ratings.rating)
FROM restaurants
join ratings on (restaurants.id = ratings.restaurantid)
join deliveryarea on (restaurants.id = deliveryarea.id)
WHERE restaurants.open = '1'
AND restaurants.name like '" . $keyword2 . "'
AND deliveryarea.`" . $quarter . "` <> ''
AND REPLACE(deliveryarea.`" . $quarter . "`, ',', '.') * 1
BETWEEN '" . $orderamountmin . "' AND '" . $orderamountmax . "'
group by restaurants.id
HAVING avg(ratings.rating) > '" . $ratingmin . "'
ORDER BY name ASC";