CHANNEL
ALL VIDEOS
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
MOST POPULAR
Fetch Rows Failure: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY
gtv_video.id
ORDER BY
rank DESC, gtv_video.post_date ASC, RA' at line 12
SQL: SELECT gtv_video.*, COUNT(gtv_video_view.id) AS rank FROM gtv_video LEFT JOIN gtv_video_view ON gtv_video_view.video_id = gtv_video.id LEFT JOIN gtv_channel_video ON gtv_channel_video.video_id = gtv_video.id WHERE gtv_video.approved = 1 AND gtv_video_view.post_date >= 1259574284 AND gtv_channel_video.channel_id = GROUP BY gtv_video.id ORDER BY rank DESC, gtv_video.post_date ASC, RAND() LIMIT 0, 5
SQL: SELECT gtv_video.*, COUNT(gtv_video_view.id) AS rank FROM gtv_video LEFT JOIN gtv_video_view ON gtv_video_view.video_id = gtv_video.id LEFT JOIN gtv_channel_video ON gtv_channel_video.video_id = gtv_video.id WHERE gtv_video.approved = 1 AND gtv_video_view.post_date >= 1259574284 AND gtv_channel_video.channel_id = GROUP BY gtv_video.id ORDER BY rank DESC, gtv_video.post_date ASC, RAND() LIMIT 0, 5