We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query: SELECT p.id, c.catname, c.catname1, c.commonname, p.bigimage,
p.userid, u.username AS user, p.cat, p.approved,
p.gender, p.reliability, p.priority, p.party, p.stage, p.date,
p.eddatetime, p.eduserid, eu.username AS edusername,
c1.id c1id, c2.id c2id, c3.id c3id, p.title, p.reliability_userid, p.reliabilitydatetime,
ru.username AS reliabilityusername, p.medsize, p.date_time, p.location,
(select count(*) from ppi_comments cn1 where cn1.photo = p.id) as comments,
c1.catname as c1catname, c2.catname as c2catname, c3.catname as c3catname,
p.md5100, p.md5150, p.md5200, p.md5300, p.md5400, p.md5600, p.md5box100, p.md5box200
FROM
(SELECT p.id
FROM ppi_cats_tree t
JOIN ppi_photos p ON p.cat=t.catid
JOIN ppi_categories c ON c.id=p.cat
WHERE (t.parentid=84547) AND COALESCE(p.approved, 0) <> 0
ORDER BY eddatetime desc, date desc, id desc
LIMIT 40 OFFSET 0
) AS p1
JOIN ppi_photos p ON p.id=p1.id
LEFT JOIN ppi_categories c ON c.id = p.cat
LEFT JOIN ppi_categories c1 ON c1.id = c.parent
LEFT JOIN ppi_categories c2 ON c2.id = c1.parent
LEFT JOIN ppi_categories c3 ON c3.id = c2.parent
LEFT JOIN ppi_users u ON u.userid = p.userid
LEFT JOIN ppi_users eu ON eu.userid = p.eduserid
LEFT JOIN ppi_users ru ON ru.userid = p.reliability_userid
AND COALESCE(p.approved, 0) <> 0
ORDER BY eddatetime desc, date desc, id desc
Result: Column 'eddatetime' in order clause is ambiguous
Database handle: Resource id #7
|
|