Residence

SET NAMES 'utf8'

SET NAMES 'utf8'

SELECT `name`,`value` 
FROM Ecy330_config  
WHERE `type` NOT 
    AND'divider')

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT * 
FROM Ecy330_categories  
WHERE `path` = 'Residence'AND `status` = 'active' 
LIMIT 0, 1

SELECT `parent_id` 
FROM Ecy330_flat_structure  
WHERE `category_id` = '111'

SELECT 1 
FROM Ecy330_categories 
WHERE `id` 
    AND'111')AND status <> 'active'

SELECT * 
FROM Ecy330_categories  
WHERE `id` IN ('0','111')AND `confirmation` = '1' 
LIMIT 0, 1

SELECT `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '0' 
LIMIT 0, 1

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT DISTINCT `blocks`.* 
FROM `Ecy330_blocks` `blocks` 
    LEFT JOIN `Ecy330_block_show` `block_show`
        ON `blocks`.`id` = `block_show`.`block_id` 
WHERE `blocks`.`status` = 'active'AND `blocks`.`name` != 'account'AND (`blocks`.`sticky` = '1'OR `block_show`.`page` = 'index_browse'OR REPLACE(`block_show`.`page`, 'index_browse|', '') = '111' )AND `blocks`.`plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `blocks`.`position`, `blocks`.`order`

SELECT `value` 
FROM Ecy330_language  
WHERE `key` = 'block_title_blc7'AND `code` = 'it' 
LIMIT 0, 1

SELECT `value` 
FROM Ecy330_language  
WHERE `key` = 'block_content_blc7'AND `code` = 'it' 
LIMIT 0, 1

SELECT `bp`.*, `p`.*, `c`.`title`, `c`.`path` 
FROM `Ecy330_block_pages` `bp` 
    LEFT JOIN `Ecy330_pages` `p`
        ON `bp`.`page_name` = `p`.`name` 
    LEFT JOIN `Ecy330_categories` `c`
        ON `c`.`id` = REPLACE(`bp`.`page_name`, 'index_browse|', '') 
WHERE `bp`.`block_name` = 'inventory' 
ORDER BY `bp`.`id`

SELECT DISTINCT `actions`.`name`, `actions`.* 
FROM `Ecy330_actions` `actions` 
    LEFT JOIN `Ecy330_action_show` `action_show`
        ON `actions`.`name` = `action_show`.`action_name` 
WHERE `action_show`.`page` = 'index_browse'AND `actions`.`name` != 'report' 
ORDER BY `actions`.`order`

SELECT t1.*, t1.`title` `title`, `t3`.`path` `path` , 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval` 
FROM `Ecy330_listings` t1 
    LEFT JOIN `Ecy330_categories` t3
        ON t1.`category_id` = t3.`id` 
WHERE t1.`status` = 'active'AND `t1`.`featured` = '1'AND t3.`status` = 'active'AND t3.`hidden` = '0'AND t1.`category_id` <> '111' 
GROUP BY t1.`id` 
ORDER BY RAND() 
LIMIT 0, 5

SELECT t1.*, t1.`title` `title`, `t3`.`path` `path` , 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval` 
FROM `Ecy330_listings` t1 
    LEFT JOIN `Ecy330_categories` t3
        ON t1.`category_id` = t3.`id` 
WHERE t1.`status` = 'active'AND `t1`.`partner` = '1'AND t3.`status` = 'active'AND t3.`hidden` = '0'AND t1.`category_id` <> '111' 
GROUP BY t1.`id` 
ORDER BY RAND() 
LIMIT 0, 3

SELECT * 
FROM `Ecy330_listing_fields` `listing_fields` 
    LEFT JOIN `Ecy330_field_categories` `field_categories`
        ON `field_categories`.`field_id` = `listing_fields`.`id` 
WHERE `type`='image'AND `instead_thumbnail`=1AND (`field_categories`.`category_id` = '' ) 
GROUP BY `listing_fields`.`id` 
ORDER BY `order` ASC 
LIMIT 1

SELECT `name`, `value` 
FROM Ecy330_listing_visual_options  
WHERE `show` = 1

SELECT `parent_id`,`title`,`page_title`,`path`, `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '111' 
LIMIT 0, 1

SELECT `parent_id`,`title`,`page_title`,`path`, `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '0' 
LIMIT 0, 1

(SELECT t1.*, '0' `crossed`, t21.`num_cols`, t1.`title` `category_title` 
FROM `Ecy330_categories` t1 
    LEFT JOIN `Ecy330_flat_structure` t2
        ON t1.`id` = t2.`parent_id` 
    LEFT JOIN `Ecy330_categories` t21
        ON t1.`parent_id` = t21.`id` 
WHERE t1.`parent_id` = '111'AND t1.`status` = 'active'AND t1.`hidden` = '0' 
GROUP BY t1.`id` 
ORDER BY t1.`title` 
LIMIT 0, 10000) UNION ALL (SELECT t1.*, '1' `crossed`, t21.`num_cols`, 
    IF((`t2`.`category_title` <> ''), t2.`category_title`, t1.`title`) `category_title` 
FROM `Ecy330_categories` t1 
        RIGHT JOIN `Ecy330_crossed` t2
        ON t1.`id` = t2.`crossed_id` 
    LEFT JOIN `Ecy330_flat_structure` t3
        ON t1.`id` = t3.`parent_id` 
    LEFT JOIN `Ecy330_categories` t21
        ON t1.`parent_id` = t21.`id` 
WHERE t2.`category_id` = '111'AND t1.`status` = 'active'AND t1.`hidden` = '0' 
GROUP BY t2.`id` 
ORDER BY t1.`title` 
LIMIT 0, 10000)  
ORDER BY `category_title`

SELECT `id` 
FROM `Ecy330_category_clicks` 
WHERE `ip` = '54.162.105.6'AND `category_id` = '111'AND (TO_DAYS(NOW()) - TO_DAYS(`date`)) <= 1 

INSERT INTO `Ecy330_category_clicks` (`category_id`,`ip`,`date`) VALUES('111','54.162.105.6',NOW())

UPDATE `Ecy330_categories` SET `clicks` = clicks+1 
WHERE id = '111'

SELECT SQL_CALC_FOUND_ROWS  DISTINCTROW  `t1`.`id`, `t1`.*, 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`, 
    IF((`t1`.`sponsored` = '1'), '3', 
    IF((`t1`.`featured` = '1'), '2', 
    IF((`t1`.`partner` = '1'), '1', '0'))) `listing_type`, (SELECT `username` `account_username` 
FROM `Ecy330_accounts` `accounts` 
WHERE `t1`.`account_id` = `accounts`.`id`) `account_username`, '0' `account_id_edit` , 
    IF((`t2`.`category_id` = '111'), '1', '0') `crossed`, '0' `favorite` 
FROM `Ecy330_listings` `t1` 
    LEFT JOIN `Ecy330_listing_categories` `t2`
        ON `t1`.`id` = `t2`.`listing_id` 
WHERE (`t2`.`category_id` = '111' OR `t1`.`category_id` = '111') AND `t1`.`status` = 'active' 
ORDER BY `listing_type` DESC, `t1`.`title` ASC 
LIMIT 12, 12

SELECT FOUND_ROWS()

SELECT path 
FROM Ecy330_categories  
WHERE `id`='176' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='176' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='133' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='133' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='205' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='205' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='156' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='156' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='184' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='184' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='188' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='188' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='81' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='81' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='197' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='197' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='82' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='82' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='172' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='172' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='189' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='189' 
LIMIT 0, 1

SELECT path 
FROM Ecy330_categories  
WHERE `id`='130' 
LIMIT 0, 1

SELECT title 
FROM Ecy330_categories  
WHERE `id`='130' 
LIMIT 0, 1

SELECT COUNT(DISTINCT t1.`category_id`) 
FROM `Ecy330_flat_structure` t1 
    LEFT JOIN `Ecy330_categories` t2
        ON t1.`category_id` = t2.`id` 
WHERE t1.`parent_id` = '111'AND t2.`status` = 'active' 

{if $config.ckeditor_code_highlighting}
	{ia_add_media files='js:js/utils/syntaxhighlighter/js/core-min, css:js/utils/syntaxhighlighter/css/shCore-min, css:js/utils/syntaxhighlighter/css/shCoreDefault-min, css:js/utils/syntaxhighlighter/css/shThemeDefault-min'}

<script type="text/javascript">
<!--
SyntaxHighlighter.autoloader(
	['applescript', 'js/utils/syntaxhighlighter/js/shBrushAppleScript-min.js'],
	['actionscript3 as3', 'js/utils/syntaxhighlighter/js/shBrushAS3-min.js'],
	['bash shell', 'js/utils/syntaxhighlighter/js/shBrushBash-min.js'],
	['coldfusion cf', 'js/utils/syntaxhighlighter/js/shBrushColdFusion-min.js'],
	['c# c-sharp csharp', 'js/utils/syntaxhighlighter/js/shBrushCSharp-min.js'],
	['cpp c', 'js/utils/syntaxhighlighter/js/shBrushCpp-min.js'],
	['css', 'js/utils/syntaxhighlighter/js/shBrushCss-min.js'],
	['java', 'js/utils/syntaxhighlighter/js/shBrushJava-min.js'],
	['js jscript javascript', 'js/utils/syntaxhighlighter/js/shBrushJScript-min.js'],
	['objective-c objc cocoa', 'js/utils/syntaxhighlighter/js/shBrushObjC-min.js'],
	['perl pl', 'js/utils/syntaxhighlighter/js/shBrushPerl-min.js'],
	['php', 'js/utils/syntaxhighlighter/js/shBrushPhp-min.js'],
	['text plain', 'js/utils/syntaxhighlighter/js/shBrushPlain-min.js'],
	['py python', 'js/utils/syntaxhighlighter/js/shBrushPython-min.js'],
	['rails ror ruby', 'js/utils/syntaxhighlighter/js/shBrushRuby-min.js'],
	['sql', 'js/utils/syntaxhighlighter/js/shBrushSql-min.js'],
	['vb vbnet', 'js/utils/syntaxhighlighter/js/shBrushVb-min.js'],
	['xml xhtml xslt html', 'js/utils/syntaxhighlighter/js/shBrushXml-min.js']
);
SyntaxHighlighter.defaults['auto-links'] = true;
SyntaxHighlighter.defaults['toolbar'] = false;
SyntaxHighlighter.all();
-->
</script>
{/if}