(string)
SELECT p.photo_id, p.server_id, p.album_id, p.hash, p.orientation, p.caption, p.description,
p.ext, p.type, p.rating, p.likes, p.rated_by, p.percent, p.total_views, p.total_comments,
p.total_favorites, p.allow_rating, p.allow_comment, p.add_time, p.errno, p.status,
pa.user_id, pa.title, pa.slug, pa.type, pa.total_photos, pa.premium, pa.status as album_status,
u.username, u.subscribers, s.photo_url
FROM photo AS p
LEFT JOIN photo_albums AS pa ON (pa.album_id = p.album_id)
LEFT JOIN user AS u ON (u.user_id = pa.user_id)
LEFT JOIN server AS s ON (s.server_id = p.server_id)
WHERE p.photo_id = ?
LIMIT 1
(string)
SELECT p.photo_id, p.server_id, p.album_id, p.hash, p.orientation, p.caption, p.description,
p.ext, p.type, p.rating, p.likes, p.rated_by, p.percent, p.total_views, p.total_comments,
p.total_favorites, p.allow_rating, p.allow_comment, p.add_time, p.errno, p.status,
pa.user_id, pa.title, pa.slug, pa.type, pa.total_photos, pa.premium, pa.status as album_status,
u.username, u.subscribers, s.photo_url
FROM photo AS p
LEFT JOIN photo_albums AS pa ON (pa.album_id = p.album_id)
LEFT JOIN user AS u ON (u.user_id = pa.user_id)
LEFT JOIN server AS s ON (s.server_id = p.server_id)
WHERE p.photo_id = ?
LIMIT 1
MySQLi query has prepared entries, but no types or variables specified!