Photo Guide to Invertebrates, Plants & Fungi
Home  »    Insecta (Arthropoda - Hexapoda)  »    Hemiptera - Heteroptera  »  << >>   Tingidae 
Home  »  Insects  »  True bugs  »  · · · 
Taxa    
      Search    
Recent Photos 1 day  7 days  14 days  all
Images 1 to 1 of 1  
View   Per Page 
  Tingidae - detailed info (show)...
Каталог-определитель объектов макросьемки: Насекомых, Паукообразных, Растений и т.п.
English Russian   Home  ·  Tree  ·  Checklists  ·  Determination  ·  Map  ·  Forum  ·  Links  ·  Files  ·  Blogs  ·  Help  ·    Home · Search · Comments · Contributors · Register · Login   |  
Username:   Password:
 
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=601) 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



2005-2023 (c) Macroid.ru - Классификатор-определить объектов природы