File: /home/merlana/domains/merlana.lt/public_html/modules/content/inc/page_data.cls.php
Line: 609

Function: get_catalog_items()

Bad mysql query:
SELECT DISTINCT pages_desc.s_id, pages.*, pages_desc.cat_id, pages_desc.lang, pages_desc.address, pages_desc.metatags, pages_desc.title, pages_desc.descr, pages_desc.price_min, pages_desc.price_max, pages_desc.action_start, pages_desc.action_end, pages_desc.action_price_min, pages_desc.action_price_max, pages_desc.count, pages_desc.created, pages.parent AS parent_id, (SELECT active_lang FROM pages WHERE s_id = parent_id LIMIT 1) as parent_active_lang FROM pages LEFT JOIN pages_desc ON pages.s_id = pages_desc.s_id AND pages_desc.lang = 'lt' LEFT JOIN parprassoc ON pages.s_id = parprassoc.s_id WHERE 1 AND pages.tree LIKE '%\_3036\_%' AND pages.active_lang & 1 > 0 /*AND pages_desc.title <> ''*/ AND ( pages.type = 'pr' OR pages.type = 'mrr' ) GROUP BY pages_desc.s_id HAVING ( parent_active_lang & 1 > 0 )

Server returned:
Error on delete of '/var/tmp/#sql-temptable-52f-16585e4e-0.MAD' (Errcode: 2 "No such file or directory")