Moeilijke Querie

SELECT rel.n , rel.a , rel.season , rel.f ,rel.epi ,info.n, info.genres , info.tekst,info.image
FROM tvseeker as rel, tvseeker_info as info

WHERE rel.n=info.n 

AND rel.a=(SELECT max(a) FROM tvseeker WHERE 	n=rel.n ) 

AND rel.season=(SELECT max(season) FROM tvseeker WHERE 	n=rel.n )  

AND b.epi=(SELECT max(epi) FROM tvseeker WHERE 	n=rel.n AND season=rel.season ) 
AND b.cat='1' AND  (b.f='1' OR b.f='3') 
 GROUP BY rel.n ORDER BY  rel.a DESC

SELECT rel.n , rel.a , rel.season , rel.f ,rel.epi ,info.n, info.genres , info.tekst,info.image
FROM tvseeker AS rel, tvseeker_info AS info
 
WHERE rel.n=info.n 
 
AND rel.a=(SELECT max(a) FROM tvseeker WHERE 	n=rel.n ) 
 
AND rel.season=(SELECT max(season) FROM tvseeker WHERE 	n=rel.n )  
 
AND b.epi=(SELECT max(epi) FROM tvseeker WHERE 	n=rel.n AND season=rel.season ) 
AND b.cat='1' AND  (b.f='1' OR b.f='3') 
 GROUP BY rel.n ORDER BY  rel.a DESC

SELECT rel.n, rel.a, rel.season, rel.f, rel.v, rel.epi, info.genres, info.tekst, info.image
FROM tvseeker rel INNER JOIN (

SELECT rel_extra.n, max( rel_extra.a ) AS a, MAX( rel_extra.season ) AS season, info_extra.genres, info_extra.tekst, info_extra.image
FROM tvseeker AS rel_extra

INNER JOIN (

SELECT genres, n, tekst, image
FROM tvseeker_info)  

AS  info_extra ON rel_extra.n =  info_extra.n
GROUP BY info_extra.n
) 

AS  info ON rel.n = info.n   AND rel.a = info.a  
AND rel.season =info.season
AND (rel.f = '1' OR rel.f = '3')
GROUP BY rel.n
ORDER BY rel.a DESC

SELECT rel.n, rel.a, rel.season, rel.f, rel.v, rel.epi, info.genres, info.tekst, info.image
FROM tvseeker rel INNER JOIN (
 
SELECT rel_extra.n, max( rel_extra.a ) AS a, MAX( rel_extra.season ) AS season, info_extra.genres, info_extra.tekst, info_extra.image
FROM tvseeker AS rel_extra
 
INNER JOIN (
 
SELECT genres, n, tekst, image
FROM tvseeker_info)  
 
AS  info_extra ON rel_extra.n =  info_extra.n
GROUP BY info_extra.n
) 
 
AS  info ON rel.n = info.n   AND rel.a = info.a  
AND rel.season =info.season
AND (rel.f = '1' OR rel.f = '3')
GROUP BY rel.n
ORDER BY rel.a DESC

SELECT tabel1.kolom1, tabel1.kolom2, tabel2.kolom1,tabel3.kolom5
FROM tabel1
INNER JOIN tabel2 (tabel1.id=tabel2.id)
INNER JOIN tabel2 (tabel1.id=table3.id)
GROUP BY tabel2.kolom1,tabel5.kolom5
ORDER BY tabel1.kolom1
LIMIT 30

SELECT tabel1.kolom1, tabel1.kolom2, tabel2.kolom1,tabel3.kolom5
FROM tabel1
INNER JOIN tabel2 (tabel1.id=tabel2.id)
INNER JOIN tabel2 (tabel1.id=table3.id)
GROUP BY tabel2.kolom1,tabel5.kolom5
ORDER BY tabel1.kolom1
LIMIT 30

  1.
      SELECT tabel1.kolom1, tabel1.kolom2, tabel2.kolom1,tabel3.kolom5
   2.
      FROM tabel1
   3.
      INNER JOIN tabel2 (tabel1.id=tabel2.id)
   4.
      INNER JOIN tabel2 (tabel1.id=table3.id)
   5.
      GROUP BY tabel2.kolom1,tabel5.kolom5
   6.
      ORDER BY tabel1.kolom1
   7.
      LIMIT 30

1.
      SELECT tabel1.kolom1, tabel1.kolom2, tabel2.kolom1,tabel3.kolom5
   2.
      FROM tabel1
   3.
      INNER JOIN tabel2 (tabel1.id=tabel2.id)
   4.
      INNER JOIN tabel2 (tabel1.id=table3.id)
   5.
      GROUP BY tabel2.kolom1,tabel5.kolom5
   6.
      ORDER BY tabel1.kolom1
   7.
      LIMIT 30

SELECT DISTINCT e1.naam, 
MAX(e1.season)over(partition by e1.naam), 
(SELECT MAX(e2.episode) FROM episodes e2 WHERE e2.naam = e1.naam GROUP BY e2.naam), s.text, s.genre 
FROM episodes e1 
LEFT JOIN Series s ON (s.naam = e1.naam);

SELECT DISTINCT e1.naam, 
MAX(e1.season)over(partition BY e1.naam), 
(SELECT MAX(e2.episode) FROM episodes e2 WHERE e2.naam = e1.naam GROUP BY e2.naam), s.text, s.genre 
FROM episodes e1 
LEFT JOIN Series s ON (s.naam = e1.naam);