MYSQL query doesn't work if row doesn't exist in a table
SELECT albums.*, MAX(albums.date) AS newDate
FROM albums, albumData
WHERE albums.userID='$id'
AND albums.state='0'
AND (
 albums.albumID=0
 OR
 albumData.id=albums.albumID
 AND albumData.state='0'
)
GROUP BY albums.albumID, albums.userID
ORDER BY newDate DESC

SELECT albums.*, MAX(albums.date) AS newDate
FROM albums WHERE userID=$id AND albums.state='0'
GROUP BY albums.albumID ORDER BY newDate DESC

if($quer['id']&&$quer['state']==0||$albumID==0)
{//do my stuff here }

SELECT  albums.*
        , MAX(albums.date) AS newDate
FROM    albums
        LEFT JOIN albumData ON albumData.id = albums.albumID
WHERE   albums.userID='$id'
        AND albums.state='0'
        AND (albums.albumID=0  OR albumData.state='0')
GROUP BY
        albums.albumID
        , albums.userID
ORDER BY
        newDate DESC