search

Brictarus / immo

personal site to make my flat search easier
0 stars 0 forks source link

Compteur de photos #4

Closed Brictarus closed 9 years ago

Brictarus commented 9 years ago

Sur la page d'accueil, sur le listing des annonces, pour chaque annonce, on doit afficher le nombre de photos disponibles

Brictarus commented 9 years ago 
SELECT a.id, a.label, count(pa.id) as cnt FROM annonce a inner join photo_annonce pa on pa.annonce_id = a.id group by pa.annonce_id
Brictarus commented 9 years ago

fix