Каталог-определитель объектов макросьемки: Насекомых, Паукообразных, Растений и т.п.
English Russian   Главная  ·  Tree  ·  Checklists  ·  Определитель  ·  Карта  ·  Форум  ·  Ссылки  ·  Файлы  ·  Блоги  ·  Инструкции  ·    Главная · Поиск · Комментарии · Авторы · Зарегистрироваться · Войти   |  
Username:   Password:
 
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT p.id,p.cat, c1.id as c1id, c2.id as c2id, c3.id as c3id, c4.id as c4id, c1.catname as c1catname, c1.catname1 as c1catname1, c2.catname as c2catname, c2.catname1 as c2catname1, c3.catname as c3catname, c3.catname1 as c3catname1, c4.catname as c4catname, c4.catname1 as c4catname1 FROM ppi_photos p LEFT JOIN ppi_categories c1 on c1.id = p.cat LEFT JOIN ppi_categories c2 on c2.id = c1.parent LEFT JOIN ppi_categories c3 on c3.id = c2.parent LEFT JOIN ppi_categories c4 on c4.id = c3.parent LEFT JOIN ppi_class_species_synonym s ON s.spec_id=c1.id WHERE p.approved=1 AND p.storecat=0 AND ((p.title LIKE "% тот%" OR p.description LIKE "% тот%" OR p.keywords LIKE "% тот%" OR p.bigimage LIKE "% тот%" OR p.extra1 LIKE "% тот%" OR p.extra2 LIKE "% тот%" OR p.extra3 LIKE "% тот%" OR p.extra4 LIKE "% тот%" OR p.extra5 LIKE "% тот%" OR p.extra6 LIKE "% тот%" OR c1.catname LIKE "% тот%" or c1.catname1 LIKE "% тот%" OR c2.catname LIKE "% тот%" or c2.catname1 LIKE "% тот%" OR c3.catname LIKE "% тот%" or c3.catname1 LIKE "% тот%" OR c4.catname LIKE "% тот%" or c4.catname1 LIKE "% тот%" OR p.location LIKE "%тот%" OR p.date_time LIKE "%тот%" ) OR (p.title LIKE "тот%" OR p.description LIKE "тот%" OR p.keywords LIKE "тот%" OR p.bigimage LIKE "тот%" OR p.extra1 LIKE "%тот%" OR p.extra2 LIKE "%тот%" OR p.extra3 LIKE "%тот%" OR p.extra4 LIKE "%тот%" OR p.extra5 LIKE "%тот%" OR p.extra6 LIKE "%тот%" OR c1.catname LIKE "%тот%" or c1.catname1 LIKE "%тот%" OR c2.catname LIKE "%тот%" or c2.catname1 LIKE "%тот%" OR c3.catname LIKE "%тот%" or c3.catname1 LIKE "%тот%" OR c4.catname LIKE "%тот%" or c4.catname1 LIKE "%тот%" OR p.location LIKE "%тот%" OR p.date_time LIKE "%тот%" OR s.name LIKE '%тот%' )) ORDER BY p.date DESC LIMIT 500

Result: Can't open file: './admin_macroid8/ppi_class_species_synonym.frm' (errno: 24)

Database handle: Resource id #7



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