CHANNEL
Greg Lyman Discusses Golf's Many Benefits
Length: :51
Aired: March 10, 2010
View Video
|
|
David Phipps Discusses the Color of Green
Length: :47
Aired: March 09, 2010
View Video
|
|
David Phipps Discusses Wildlife Refuge
Length: :45
Aired: March 08, 2010
View Video
|
|
Darren Davis Explains the Benefits of Verticutting
Length: :49
Aired: March 07, 2010
View Video
|
|
Greg Lyman Discusses the Benefits of Ponds and Streams
Length: :52
Aired: March 06, 2010
View Video
|
|
David Phipps Discusses Water Runoff Management
Length: :45
Aired: March 05, 2010
View Video
|
|
Darren Davis Discusses the Importance of Hand Watering
Length: :53
Aired: March 04, 2010
View Video
|
|
Sod Cutting Product Innovation (presented by Ryan)
Length: 3:37
Aired: March 03, 2010
View Video
|
|
Greg Lyman Discusses Native Out of Play Areas
Length: :53
Aired: March 03, 2010
View Video
|
|
Darren Davis Explains the Importance of Aeration
Length: :53
Aired: March 02, 2010
View Video
|
|
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