The query in question looks like this:
SELECT DISTINCT film_film.filmid, titel, pdf, termin, aar, film_serier.serieid, serienamn, screener, har_affisch, har_bilder, max( datum )
FROM (
(
(
`film_film`
LEFT JOIN film_rel_regissoerer ON film_film.filmid = film_rel_regissoerer.filmid_relid
)
LEFT JOIN film_regissoerer ON film_rel_regissoerer.regissoerid_relid = film_regissoerer.regissoerid
)
LEFT JOIN film_visningar ON film_film.filmid = film_visningar.filmid
)
LEFT JOIN film_serier ON film_visningar.serieid = film_serier.serieid
GROUP BY titel
Earlier, before I added the max(datum) to the query, i could get the number of rows by doing:
--- SQL ---
SELECT count( DISTINCT film_film.filmid, titel,
IF (
aar IS NULL , '', aar
),
IF (
termin IS NULL , '', termin
) ) AS antal
FROM (
(
(
`film_film`
LEFT JOIN film_rel_regissoerer ON film_film.filmid = film_rel_regissoerer.filmid_relid
)
LEFT JOIN film_regissoerer ON film_rel_regissoerer.regissoerid_relid = film_regissoerer.regissoerid
)
LEFT JOIN film_visningar ON film_film.filmid = film_visningar.filmid
)
LEFT JOIN film_serier ON film_visningar.serieid = film_serier.serieid LIMIT 0 , 30
The if-clauses where added because count returned wrong number of rows when there where NULL-values in the result…
What I need to do is to count the number of rows in the first query. But I can't figure how. Adding a max(datum) to the count-list simply wont do it; reports sql-errors…
Extremely thankful for some feedback.
Sincerely
Victor
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
