Чёт криво встала:
Рейтинг категорий
Table 'rentast_miha.z0n9z_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'rentast_miha.z0n9z_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Table 'rentast_miha.z0n9z_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc
Рейтинг изображений
Table 'rentast_miha.z0n9z_phocagallery_img_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc Table 'rentast_miha.z0n9z_phocagallery_img_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 Table 'rentast_miha.z0n9z_phocagallery_img_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_votes` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc
Комментарии категорий
Table 'rentast_miha.z0n9z_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc Table 'rentast_miha.z0n9z_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc LIMIT 0, 20 Table 'rentast_miha.z0n9z_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
Комментарии изображений
Table 'rentast_miha.z0n9z_phocagallery_img_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc Table 'rentast_miha.z0n9z_phocagallery_img_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc LIMIT 0, 20 Table 'rentast_miha.z0n9z_phocagallery_img_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `z0n9z_phocagallery_img_comments` AS a LEFT JOIN `z0n9z_languages` AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN z0n9z_phocagallery AS i ON i.id = a.imgid LEFT JOIN z0n9z_phocagallery_categories AS c ON c.id = i.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
Пользователи
Table 'rentast_miha.z0n9z_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM z0n9z_phocagallery_user AS a LEFT JOIN z0n9z_languages AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM z0n9z_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM z0n9z_phocagallery AS i LEFT JOIN z0n9z_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN z0n9z_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Table 'rentast_miha.z0n9z_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM z0n9z_phocagallery_user AS a LEFT JOIN z0n9z_languages AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM z0n9z_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM z0n9z_phocagallery AS i LEFT JOIN z0n9z_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN z0n9z_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 Table 'rentast_miha.z0n9z_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM z0n9z_phocagallery_user AS a LEFT JOIN z0n9z_languages AS l ON l.lang_code = a.language LEFT JOIN z0n9z_users AS ua ON ua.id=a.userid LEFT JOIN z0n9z_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM z0n9z_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM z0n9z_phocagallery AS i LEFT JOIN z0n9z_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN z0n9z_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc
При попытке создать изображение:
wtf?
15.02.2021, 13:23:27