Subquery returns more than 1 row i dont know <p>When i trying get the "tytul" field i catch this error</p> <pre><code> SELECT f.*, (SELECT MAX(e) FROM seriale WHERE s = MAX(k.s) AND id_serialu = f.id) as e, MAX(k.s) as s, (SELECT tytul FROM seriale c WHERE c.s = s AND c.e = e) as tytul FROM serial f LEFT JOIN seriale k ON f.id=k.id_serialu GROUP BY f.id ORDER BY f.id DESC LIMIT 25 </code></pre>