Listings : G

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 `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` = 'search'OR REPLACE(`block_show`.`page`, 'index_browse|', '') = '0' )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` = 'search'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' 
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' 
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 `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_listing_fields` 
WHERE `adminonly` = '0'AND searchable <> '0'
ORDER BY `order` ASC 

SELECT `name` 
FROM Ecy330_field_groups  
WHERE FIND_IN_SET('search', `pages`) ORDER by `order`

SELECT SQL_CALC_FOUND_ROWS `t44`.*, `t44`.`path` `path`, `t44`.`title` `category_title` 
FROM `Ecy330_categories` `t44` 
WHERE ((CONCAT(`t44`.`title`,' ',`t44`.`description`)LIKE '%alphaSearch%'))AND `t44`.`status` = 'active'AND `t44`.`hidden` = '0'AND `t44`.`parent_id` != '-1'  
ORDER BY `t44`.`num_all_listings` DESC 
LIMIT 0, 10

SELECT FOUND_ROWS()

SELECT SQL_CALC_FOUND_ROWS `listings`.*, `categories`.`path`, `categories`.`title` `category_title`, `categories`.`path` `category_path`, `locations`.`title` `location_title`, `locations`.`path` `location_path`, (SELECT `username` `account_username` 
FROM `Ecy330_accounts` `accounts` 
WHERE `listings`.`account_id` = `accounts`.`id`) `account_username`, 
    IF (`listings`.`sponsored` = '1', '3', 
    IF (`listings`.`featured` = '1', '2', 
    IF (`listings`.`partner` = '1', '1', '0'))) `listing_type`, 
    IF ((`listings`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`, '0' `favorite`, '0' `account_id_edit` 
FROM `Ecy330_listings` `listings` 
    LEFT JOIN `Ecy330_categories` `categories`
        ON `categories`.`id` = `listings`.`category_id` 
    LEFT JOIN `Ecy330_locations_listings` `locations_listings`
        ON `locations_listings`.`listing_id` = `listings`.`id` 
    LEFT JOIN `Ecy330_locations` `locations`
        ON `locations`.`id` = `locations_listings`.`location_id` 
WHERE `categories`.`status` = 'active'AND `listings`.`status` = 'active'AND `categories`.`hidden` = '0'AND (`listings`.`title`LIKE 'G%')AND (`listings`.`status` = 'active')  
GROUP BY `listings`.`id` 
ORDER BY `listing_type` DESC, `listings`.`date` DESC  
LIMIT 0, 12

SELECT FOUND_ROWS()

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 REPLACE(`key`, 'page_content_', ''), `value` 
FROM `Ecy330_language` 
WHERE `category` = 'page'AND `plugin` IS nullAND `code` = 'it'AND `key`LIKE 'page_content_%'AND `value`LIKE '%alphaSearch%'

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`

{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}