(string)
SELECT c.channel_id, c.orientation, c.user_id, c.name, c.slug, c.description, c.url,
c.thumb, c.logo, c.total_videos, c.total_albums, c.total_photos,
c.video_views, c.album_views, c.total_views, c.total_subscribers,
c.likes, c.rating, c.rated_by, c.rank, c.rank_prev, c.add_time, c.status,
GROUP_CONCAT(t.tag) AS tags
FROM channel AS c
LEFT JOIN channel_networks AS cn ON (cn.network_id = c.network_id)
LEFT JOIN user AS u ON (u.user_id = c.user_id AND u.status = 1)
LEFT JOIN channel_tags AS ct ON (ct.channel_id = c.channel_id)
LEFT JOIN tags AS t ON (t.tag_id = ct.tag_id)
WHERE c.slug = ?
GROUP BY c.channel_id
LIMIT 1
(string)
SELECT c.channel_id, c.orientation, c.user_id, c.name, c.slug, c.description, c.url,
c.thumb, c.logo, c.total_videos, c.total_albums, c.total_photos,
c.video_views, c.album_views, c.total_views, c.total_subscribers,
c.likes, c.rating, c.rated_by, c.rank, c.rank_prev, c.add_time, c.status,
GROUP_CONCAT(t.tag) AS tags
FROM channel AS c
LEFT JOIN channel_networks AS cn ON (cn.network_id = c.network_id)
LEFT JOIN user AS u ON (u.user_id = c.user_id AND u.status = 1)
LEFT JOIN channel_tags AS ct ON (ct.channel_id = c.channel_id)
LEFT JOIN tags AS t ON (t.tag_id = ct.tag_id)
WHERE c.slug = ?
GROUP BY c.channel_id
LIMIT 1
MySQLi query has prepared entries, but no types or variables specified!