requete sql and modx

225 Posts

lolotlm Reply #1, 15 years, 10 months ago

hi,

i want to do this requete with modx

SELECT t1.nom, t1.ville, COMPTEUR
FROM modx_DbCustom_salleConcert t1, (

SELECT nom, ville, COUNT( * ) AS COMPTEUR
FROM modx_DbCustom_salleConcert
GROUP BY nom
HAVING COUNT( * ) >1
)t2
WHERE t1.nom = t2.nom and t1.ville = t2.ville order by t1.nom ASC

how to do this ?

thanks for your help

Laurent

- ☆ A M B ☆
- 3,141 Posts
Mark Hamstra Reply #2, 15 years, 10 months ago

Have a look at this post: http://modxcms.com/forums/index.php/topic,28633.msg174080.html#msg174080

( Assuming you’re on Revolution )
Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.