We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query: SELECT c.id,c.parent,c.catname,c.description,c.photos,c.posts,c.private,
p.userid, p.user, p.bigimage, p.cat, p.storecat, p.approved, p.width, p.height,
p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.user, p2.id as thumbnail, c.catname1,
c.commonname, p2.width, p2.height, p.date as lastphodate, com.date as lastcomdate, c.taxon,
(SELECT pp.id FROM ppi_photos pp WHERE pp.cat=c.id AND pp.priority=1 LIMIT 1) priocat,
(SELECT pp.id FROM ppi_photos pp WHERE pp.cat=c.id AND pp.priority=-1 LIMIT 1) autopriocat,
(SELECT pp.id FROM ppi_photos pp WHERE pp.cat=c.id LIMIT 1) hasphoto,
(SELECT g.id FROM ppi_photos p
JOIN ppi_geolocation g on g.photo=p.id AND g.state=1
WHERE p.cat=c.id LIMIT 1) onmap
FROM ppi_categories c
LEFT JOIN ppi_photos p ON p.id=c.lastphoto
LEFT JOIN ppi_comments com ON com.id=c.lastpost
LEFT JOIN ppi_photos p2 ON p2.id=c.thumbnail WHERE (c.parent=137695) AND c.subfamily_id= AND c.id <> 500 AND ((EXISTS(SELECT id FROM ppi_photos where cat=c.id)) OR
(EXISTS(SELECT id FROM ppi_categories where parent=c.id)) OR
(EXISTS(SELECT rc.id FROM ppi_regioncat rc WHERE rc.catid=c.id)) OR
c.region <> '') ORDER BY c.catname, c.catname1, c.id
Result: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND c.id <> 500 AND ((EXISTS(SELECT id FROM ppi_photos where cat=c.id)) OR
' at line 14
Database handle: Resource id #7
|
|