Forum Moderators: open
// Returns something like:
// 10 | Cars
// 20 | Trucks
// 30 | ATVs
SELECT sorter, subcat FROM classifieds_cats
WHERE category='Autos'
ORDER BY sorter, subcat
// Returns something like:
// Cars | 120
// Trucks | 113
// ATVs | 48
SELECT subcat, COUNT(subcat) AS nums
FROM classifieds
WHERE category = 'Autos'
GROUP BY subcatSELECT
classifieds_cats.sorter,
classifieds_cats.subcat,
COUNT(classifieds.subcat) AS nums
FROM classifieds_cats
LEFT JOIN classifieds
ON classifieds.category = classifieds_cats.category
WHERE classifieds_cats.category = 'Autos'
GROUP BY classifieds_cats.subcat
ORDER BY sorter, subcat// 10 | Cars | 120
// 20 | Trucks | 113
// 30 | ATVs | 48// 10 | Cars | 281
// 20 | Trucks | 281
// 30 | ATVs | 281
SELECT classifieds_cats.sorter, classifieds_cats.subcat, COUNT(classifieds.subcat) AS nums
FROM classifieds_cats
LEFT JOIN classifieds ON classifieds.category = classifieds_cats.category
WHERE classifieds_cats.category = 'Autos'
GROUP BY classifieds_cats.sorter, classifieds_cats.subcat
ORDER BY sorter, subcat
SELECT classifieds_cats.sorter, classifieds.subcat, COUNT(classifieds.subcat) AS nums
FROM classifieds
LEFT JOIN classifieds_cats ON classifieds.category = classifieds_cats.category
WHERE classifieds.category = 'Autos'
GROUP BY classifieds_cats.sorter, classifieds.subcat
ORDER BY sorter, subcat
// 10 | Cars | 120
// 10 | Trucks | 113
// 10 | ATVs | 48
// 20 | Cars | 120
// 20 | Trucks | 113
// 20 | ATVs | 48
// 30 | Cars | 120
// 30 | Trucks | 113
// 30 | ATVs | 48
