Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL: Invalid Query: SELECT
- tg.Name,
- tg.ID,
- CASE COUNT(ta.GroupID)
- WHEN 1 THEN aa.ArtistID
- WHEN 0 THEN '0'
- ELSE '0'
- END AS ArtistID,
- CASE COUNT(ta.GroupID)
- WHEN 1 THEN aa.Name
- WHEN 0 THEN ''
- ELSE 'Various Artists'
- END AS ArtistName,
- tg.Year,
- tg.CategoryID,
- t.Time,
- t.Remastered,
- t.RemasterTitle,
- t.RemasterYear,
- t.Media,
- t.Format,
- t.Encoding,
- t.Size,
- t.HasLog,
- t.LogScore,
- t.UserID AS UploaderID,
- uploader.Username
- FROM torrents AS t
- LEFT JOIN torrents_group AS tg ON tg.ID=t.GroupID
- LEFT JOIN torrents_artists AS ta ON ta.GroupID=tg.ID AND ta.Importance='1'
- LEFT JOIN artists_alias AS aa ON aa.AliasID=ta.AliasID
- LEFT JOIN users_main AS uploader ON uploader.ID=t.UserID
- WHERE t.ID=1 SQL error: 1140 (Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause)
- Array ( [0] => Array ( [0] => SELECT ID, Name, Level FROM permissions ORDER BY Level [1] => 0.20813941955566 ) [1] => Array ( [0] => SELECT SessionID, Browser, OperatingSystem, IP, LastUpdate FROM users_sessions WHERE UserID='1' ORDER BY LastUpdate DESC [1] => 0.051021575927734 ) [2] => Array ( [0] => SELECT Enabled FROM users_main WHERE ID='1' [1] => 0.042200088500977 ) [3] => Array ( [0] => SELECT Uploaded AS BytesUploaded, Downloaded AS BytesDownloaded, RequiredRatio FROM users_main WHERE ID='1' [1] => 0.041961669921875 ) [4] => Array ( [0] => SELECT m.ID, m.Username, m.PermissionID, i.Artist, i.Donor, i.Warned, i.Avatar, m.Enabled, m.Title, i.CatchupTime, m.Visible FROM users_main AS m INNER JOIN users_info AS i ON i.UserID=m.ID WHERE m.ID='1' [1] => 0.046014785766602 ) [5] => Array ( [0] => SELECT m.Invites, m.torrent_pass, m.IP, m.CustomPermissions, i.AuthKey, i.RatioWatchEnds, i.RatioWatchDownload, i.StyleID, i.StyleURL, i.DisableInvites, i.DisablePosting, i.DisableUpload, i.DisableWiki, i.DisableAvatar, i.DisablePM, i.SiteOptions, i.DownloadAlt FROM users_main AS m INNER JOIN users_info AS i ON i.UserID=m.ID WHERE m.ID='1' [1] => 0.054121017456055 ) [6] => Array ( [0] => SELECT p.Level AS Class, p.Values as Permissions FROM permissions AS p WHERE ID='15' [1] => 0.044107437133789 ) [7] => Array ( [0] => SELECT ID, Label FROM users_notify_filters WHERE UserID='1' [1] => 0.042915344238281 ) [8] => Array ( [0] => SELECT ID, LOWER(REPLACE(Name," ","_")) AS Name, Name AS ProperName FROM stylesheets [1] => 0.041961669921875 ) [9] => Array ( [0] => SELECT t.UserID, t.Time, COUNT(x.uid) FROM torrents AS t LEFT JOIN xbt_snatched AS x ON x.fid=t.ID WHERE t.ID=1 GROUP BY t.UserID [1] => 0.29587745666504 ) [10] => Array ( [0] => SELECT COUNT(UnRead) FROM pm_conversations_users WHERE UserID='1' AND UnRead = '1' [1] => 0.046014785766602 ) [11] => Array ( [0] => SELECT COUNT(UserID) FROM users_notify_torrents WHERE UserID='1' AND UnRead='1' [1] => 0.041007995605469 ) [12] => Array ( [0] => SELECT COUNT(ID) FROM reportsv2 WHERE Status='New' [1] => 0.040054321289062 ) [13] => Array ( [0] => SELECT COUNT(ID) FROM reports WHERE Status='New' [1] => 0.038862228393555 ) [14] => Array ( [0] => SELECT tg.Name, tg.ID, CASE COUNT(ta.GroupID) WHEN 1 THEN aa.ArtistID WHEN 0 THEN '0' ELSE '0' END AS ArtistID, CASE COUNT(ta.GroupID) WHEN 1 THEN aa.Name WHEN 0 THEN '' ELSE 'Various Artists' END AS ArtistName, tg.Year, tg.CategoryID, t.Time, t.Remastered, t.RemasterTitle, t.RemasterYear, t.Media, t.Format, t.Encoding, t.Size, t.HasLog, t.LogScore, t.UserID AS UploaderID, uploader.Username FROM torrents AS t LEFT JOIN torrents_group AS tg ON tg.ID=t.GroupID LEFT JOIN torrents_artists AS ta ON ta.GroupID=tg.ID AND ta.Importance='1' LEFT JOIN artists_alias AS aa ON aa.AliasID=ta.AliasID LEFT JOIN users_main AS uploader ON uploader.ID=t.UserID WHERE t.ID=1 [1] => 0.28300285339355 ) )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement