<br />
<b>Warning</b>:  mysql_query(): Unable to save result set in <b>/home/relaxbul/www/www/system/lib/dbclass.php</b> on line <b>87</b><br />
Server shutdown in progressSQL: SELECT 
                   e.id AS id,

                   e.office_code,
                   e.price,
                   e.code,
                   e.top_id,
                   e.date_pub,
                   UNIX_TIMESTAMP(e.date_pub) AS rss_date,

                   e.category_id,
                   e.categorization,

                   e.location_id AS location_id,

                   l.parent_id AS location_parent_id,
                   l.coordinates  AS location_coord,

                   el.title AS e_title,
                   el.description AS e_description,

                   ll.name AS el_region,
                   addll.name AS praent_region,
                   l.parent_id

                   FROM em_estates AS e
                   LEFT JOIN em_estates_description         AS el ON ( el.estate_id = e.id )
                   LEFT JOIN em_category                    AS ec ON ( ec.id = e.category_id )
                   LEFT JOIN em_multi_cats                  AS emc ON ( emc.estate = e.id )
                   LEFT JOIN em_estates_atribute            AS atr ON ( atr.estate_id = e.id )
                   LEFT JOIN em_add_category                AS eac ON ( e.id = eac.estate_id )

                   LEFT JOIN em_locations                   AS l ON ( l.id = e.location_id )
                   LEFT JOIN em_locations_lang              AS ll ON ( ll.location_id = e.location_id )
                   LEFT JOIN em_locations_lang              AS addll ON ( addll.location_id = l.parent_id )


                   WHERE el.lang_id = '2' AND e.status_id = 1 
                    AND  ( e.category_id = 29 OR ec.parent_id = 29  OR eac.category_id IN ( 29 )  )  AND  ( e.location_id IN ( 102 ) OR l.parent_id = 102 )  

                   GROUP BY e.id
                    ORDER BY e.sort ASC  LIMIT 0,10