Books

SET NAMES 'utf8'

SET NAMES 'utf8'

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

SELECT * 
FROM esc320_categories  
WHERE `path` = 'Books'AND `status` = 'active' 
LIMIT 0, 1

SELECT `parent_id` 
FROM esc320_flat_structure  
WHERE `category_id` = '22'

SELECT 1 
FROM esc320_categories 
WHERE `id` 
    AND'0')AND status <> 'active'

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

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

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

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

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM esc320_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `order`

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

SELECT b.* 
FROM `esc320_blocks` as b 
        RIGHT JOIN `esc320_banner_plan_blocks`AS pb
        ON b.`position` = pb.`block_pos` 
WHERE b.`plugin` = 'banners'

SELECT `id`,`position` 
FROM esc320_blocks  
WHERE `plugin` = 'banners'

SELECT parent_id, 1 
FROM `esc320_flat_structure`
WHERE category_id = '22'AND parent_id <> '22'

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'left'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'right'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'top'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'bottom'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'user1'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'user2'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'verybottom'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'verytop'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'inventory'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'mainmenu'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'copyright'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'footer1'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'footer2'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'footer3'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

SELECT `b`.* 
FROM `esc320_banners_categories` `bc` 
    LEFT JOIN `esc320_banners` `b`
        ON `bc`.`banner_id` = `b`.`id` 
WHERE `status` = 'active'AND `position` = 'footer4'AND (`bc`.`category_id` = '22'OR `b`.`recursive` = '1' AND `bc`.`category_id` 
    AND'0')) 
ORDER BY RAND()  
LIMIT 0, 1

UPDATE `esc320_banners` SET `showed` = `showed`+'1' 
WHERE `id` 
    AND'33','3')

SELECT DISTINCT `blocks`.* 
FROM `esc320_blocks` `blocks` 
    LEFT JOIN `esc320_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|', '') = '22' )AND `blocks`.`plugin` 
    AND'', 'kcaptcha','fancybox','slider','websnapr','googlemap','banners','categories_boxes','categoriesmap','googletools','listings_boxes','paypal','news','nova') 
ORDER BY `blocks`.`position`, `blocks`.`order`

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_title_blc10'AND `code` = 'en' 
LIMIT 0, 1

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_content_blc10'AND `code` = 'en' 
LIMIT 0, 1

SELECT * 
FROM `esc320_block_pages` `bp` 
    LEFT JOIN `esc320_pages` `p`
        ON `bp`.`page_name` = `p`.`name` 
    LEFT JOIN `esc320_categories` `c`
        ON `c`.`id` = REPLACE(`bp`.`page_name`, 'index_browse|', '') 
WHERE (`p`.`status` = 'active'AND `c`.`status` = 'active')AND `bp`.`block_name` = 'bottom' 
ORDER BY `bp`.`id`

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_title_blc7'AND `code` = 'en' 
LIMIT 0, 1

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_content_blc7'AND `code` = 'en' 
LIMIT 0, 1

SELECT * 
FROM `esc320_block_pages` `bp` 
    LEFT JOIN `esc320_pages` `p`
        ON `bp`.`page_name` = `p`.`name` 
    LEFT JOIN `esc320_categories` `c`
        ON `c`.`id` = REPLACE(`bp`.`page_name`, 'index_browse|', '') 
WHERE (`p`.`status` = 'active'AND `c`.`status` = 'active')AND `bp`.`block_name` = 'inventory' 
ORDER BY `bp`.`id`

SELECT * 
FROM `esc320_block_pages` `bp` 
    LEFT JOIN `esc320_pages` `p`
        ON `bp`.`page_name` = `p`.`name` 
    LEFT JOIN `esc320_categories` `c`
        ON `c`.`id` = REPLACE(`bp`.`page_name`, 'index_browse|', '') 
WHERE (`p`.`status` = 'active'AND `c`.`status` = 'active')AND `bp`.`block_name` = 'main' 
ORDER BY `bp`.`id`

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_title_blc30'AND `code` = 'en' 
LIMIT 0, 1

SELECT `value` 
FROM esc320_language  
WHERE `key` = 'block_content_blc30'AND `code` = 'en' 
LIMIT 0, 1

SELECT DISTINCT `actions`.`name`, `actions`.* 
FROM `esc320_actions` `actions` 
    LEFT JOIN `esc320_action_show` `action_show`
        ON `actions`.`name` = `action_show`.`action_name` 
WHERE `action_show`.`page` = 'index_browse' 
ORDER BY `actions`.`order`

SELECT t1.*, t1.`title` `title`, `t3`.`path` `path` , 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval` 
FROM `esc320_listings` t1 
    LEFT JOIN `esc320_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` <> '22' 
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 `esc320_listings` t1 
    LEFT JOIN `esc320_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` <> '22' 
GROUP BY t1.`id` 
ORDER BY RAND() 
LIMIT 0, 3

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

SELECT * 
FROM esc320_slides  
WHERE `category_id` = 22AND `status` = 'active' 
ORDER BY `order` ASC 
LIMIT 0, 5

SELECT * 
FROM esc320_categories  
WHERE `level` = '1'AND `status` = 'active' 
ORDER BY `title` ASC 
LIMIT 0, 10

SELECT * 
FROM esc320_categories  
WHERE `parent_id` != '-1'AND `status` = 'active' 
ORDER BY `clicks` DESC 
LIMIT 0, 10

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 `esc320_accounts` `accounts` 
WHERE `categories`.`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 `esc320_listings` `listings` 
    LEFT JOIN `esc320_categories` `categories`
        ON `categories`.`id` = `listings`.`category_id` 
    LEFT JOIN `esc320_locations_listings` `locations_listings`
        ON `locations_listings`.`listing_id` = `listings`.`id` 
    LEFT JOIN `esc320_locations` `locations`
        ON `locations`.`id` = `locations_listings`.`location_id` 
WHERE `categories`.`status` = 'active'AND `listings`.`status` = 'active'AND `categories`.`hidden` = '0'  
GROUP BY `listings`.`id` 
ORDER BY `listings`.`date` DESC 
LIMIT 0, 10

SELECT COUNT(*) 
FROM esc320_listings 

SELECT MAX(`id`) 
FROM esc320_listings 

SELECT SQL_CALC_FOUND_ROWS t1.*, t9.`path`, t9.`title` `category_title`, t9.`path` `category_path`, '0' `account_id_edit`, (SELECT `username` `account_username` 
FROM `esc320_accounts` `accounts` 
WHERE `t1`.`account_id` = `accounts`.`id`) `account_username`, 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval`, '0' `favorite` 
FROM `esc320_listings` t1 
    LEFT JOIN `esc320_categories` t9
        ON t1.`category_id` = t9.`id` 
WHERE t9.`status` = 'active'AND t9.`hidden` = '0'AND t1.`status` = 'active'AND t1.`id` 
    AND'969','278','222','369','1700') 
LIMIT 5

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 `esc320_accounts` `accounts` 
WHERE `categories`.`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 `esc320_listings` `listings` 
    LEFT JOIN `esc320_categories` `categories`
        ON `categories`.`id` = `listings`.`category_id` 
    LEFT JOIN `esc320_locations_listings` `locations_listings`
        ON `locations_listings`.`listing_id` = `listings`.`id` 
    LEFT JOIN `esc320_locations` `locations`
        ON `locations`.`id` = `locations_listings`.`location_id` 
WHERE `categories`.`status` = 'active'AND `listings`.`status` = 'active'AND `categories`.`hidden` = '0'  
GROUP BY `listings`.`id` 
ORDER BY `listings`.`rank` DESC 
LIMIT 0, 5

SELECT `id`,`title`,`date`,`alias`,`body`,`image` 
FROM esc320_news  
WHERE `status` = 'active'AND `lang` = 'en' 
ORDER BY `date` DESC 
LIMIT 0, 3

SELECT * 
FROM `esc320_listing_fields` `listing_fields` 
    LEFT JOIN `esc320_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 esc320_listing_visual_options  
WHERE `show` = 1

SELECT `multiple_values` 
FROM esc320_config  
WHERE `name` = 'listings_sorting' 
LIMIT 0, 1

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

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

SELECT `id` 
FROM `esc320_category_clicks` 
WHERE `ip` = '52.91.185.49'AND `category_id` = '22'AND (TO_DAYS(NOW()) - TO_DAYS(`date`)) <= 1 

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 `esc320_accounts` `accounts` 
WHERE `t1`.`account_id` = `accounts`.`id`) `account_username`, `t11`.`path` `path`, `t11`.`title` `category_title`, '0' `account_id_edit` , 
    IF((`t2`.`category_id` = '22'), '1', '0') `crossed`, '0' `favorite` 
FROM `esc320_flat_structure` `t10` 
    LEFT JOIN `esc320_listings` `t1`
        ON `t10`.`category_id` = `t1`.`category_id` 
    LEFT JOIN `esc320_categories` `t11`
        ON `t11`.`id` = `t1`.`category_id` 
    LEFT JOIN `esc320_listing_categories` `t2`
        ON `t1`.`id` = `t2`.`listing_id` 
WHERE (`t2`.`category_id` = '22'OR `t10`.`parent_id` = '22'OR `t1`.`category_id` = '22') AND `t1`.`status` = 'active' 
ORDER BY `listing_type` DESC, `t1`.`clicks` DESC 
LIMIT 0, 12

SELECT FOUND_ROWS()

SELECT t1.*, '1' `related`, t21.`num_cols`, 
    IF((`t2`.`category_title` <> ''), t2.`category_title`, t1.`title`) `category_title` 
FROM `esc320_categories` t1 
        RIGHT JOIN `esc320_related` t2
        ON t1.`id` = t2.`related_id` 
    LEFT JOIN `esc320_flat_structure` t3
        ON t1.`id` = t3.`parent_id` 
    LEFT JOIN `esc320_categories` t21
        ON t1.`parent_id` = t21.`id` 
WHERE t2.`category_id` = '22'AND t1.`status` = 'active'AND t1.`hidden` = '0' 
GROUP BY t2.`id` 
ORDER BY t1.`title` 

SELECT t2.*, t2.`title` `category_title` 
FROM `esc320_categories` t1 
        RIGHT JOIN `esc320_categories` t2
        ON t1.`parent_id` = t2.`parent_id` 
    LEFT JOIN `esc320_flat_structure` t3
        ON t2.`id` = t3.`parent_id` 
    LEFT JOIN `esc320_listing_categories` t4
        ON t3.`category_id` = t4.`category_id` 
WHERE t1.`id` <> t2.`id`AND t1.`id` = '22'AND t2.`status` = 'active'
GROUP BY t2.`id` 
ORDER BY t2.`title` 
LIMIT 0, 1

SELECT COUNT(DISTINCT t1.`category_id`) 
FROM `esc320_flat_structure` t1 
    LEFT JOIN `esc320_categories` t2
        ON t1.`category_id` = t2.`id` 
WHERE t1.`parent_id` = '22'AND t2.`status` = 'active' 

SELECT `multiple_values` 
FROM esc320_config  
WHERE `name` = 'listings_sorting' 
LIMIT 0, 1

SELECT `multiple_values` 
FROM esc320_config  
WHERE `name` = 'listings_sorting' 
LIMIT 0, 1

global $eSyndiCat, $esynSmarty, $esynConfig, $category;

if ($esynConfig->getConfig('display_slider'))
{
	$categoryId = isset($category['id']) ? (int)$category['id'] : 0;

	$eSyndiCat->setTable("slides");
	$slides = $eSyndiCat->all("*", "`category_id` = {$categoryId} AND `status` = 'active' ORDER BY `order` ASC", array(), 0, $esynConfig->getConfig('num_slides'));
	$eSyndiCat->resetTable();

	$esynSmarty->assign('slides', $slides);
}

global $eSyndiCat, $esynSmarty, $esynConfig;

$eSyndiCat->setTable('categories');
$boxes_categories['top'] = $eSyndiCat->all("*", "`level` = '1' AND `status` = 'active' ORDER BY `title` ASC LIMIT 0, ".$esynConfig->getConfig('num_top_cat'));
$boxes_categories['popular'] = $eSyndiCat->all("*", "`parent_id` != '-1' AND `status` = 'active' ORDER BY `clicks` DESC LIMIT 0, ".$esynConfig->getConfig('num_popular_cat'));
$eSyndiCat->resetTable();

$esynSmarty->assign('boxes_categories', $boxes_categories);

global $eSyndiCat, $esynSmarty, $esynAccountInfo, $esynConfig, $box_listings, $esynListing;

$box_listings['new'] = $esynListing->getLatest(0, $esynConfig->getConfig('num_new_listings'), $esynAccountInfo['id']);
$box_listings['random'] = $esynListing->getRandom($esynConfig->getConfig('num_random_listings'), $esynAccountInfo['id']);
$box_listings['top'] = $esynListing->getTop(0, $esynConfig->getConfig('num_top_listings'), $esynAccountInfo['id']);

$esynSmarty->assignByRef('box_listings', $box_listings);

global $esynConfig, $esynSmarty, $eSyndiCat;

if ($esynConfig->getConfig('news'))
{
	$eSyndiCat->setTable("news");
	$news = $eSyndiCat->all("`id`,`title`,`date`,`alias`,`body`,`image`",
		"`status` = 'active' AND `lang` = '".IA_LANGUAGE."' ORDER BY `date` DESC",
		$values = array(), 0, $esynConfig->getConfig('news_number'));
	$eSyndiCat->resetTable();
	$esynSmarty->assign('news', $news);
}

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if (!empty($listing.zip) || !empty($listing.country) || !empty($listing.state) || !empty($listing.city) || !empty($listing.address)) || (!empty($listing.latitude) || !empty($listing.longitude))}
	<div class="js-map-info" id="js-map-info-{$listing.id}"
		data-id="{$listing.id}"
		data-zip="{$listing.zip}"
		data-country="{$listing.country}"
		data-state="{$listing.state}"
		data-city="{$listing.city}"
		data-address="{$listing.address}"
		data-description="{$listing.description|strip_tags|truncate:150:"..."}"
		data-title="{$listing.title|escape:'html'}"
		data-url="{print_listing_url listing=$listing}"
		data-lat="{$listing.latitude}"
		data-lng="{$listing.longitude}"
		data-zoom="{$listing.zoom}">
	</div>
{/if}

<span class="js-map-marker-{$listing.id}"></span>

{if 'fancybox' == $config.lightbox_name}
	{ia_print_css files='plugins/fancybox/js/jquery.fancybox'}
{/if}

{if 'websnapr' == $config.thumbshots_name}
	<script type="text/javascript" src="http://www.websnapr.com/js/websnapr.js"></script>
	<script type="text/javascript">
	$(document).ready(function()
	{
		$('.js-websnapr a').each(function(i, obj)
		{
			var img = $('<img>', {
				src: 'http://images.websnapr.com/?size=s&url=' + encodeURIComponent($(obj).attr('href')) + '&key={$config.websnapr_api_key}' + '&hash=' + websnapr_hash,
				width: 200
			});
			$(obj).append(img);
		});
	});
	</script>
{/if}

{$config.google_verification}

<link rel="alternate" type="application/rss+xml" title="{$news.title|escape:'html'}" href="{$smarty.const.IA_URL}feed.php?from=news" />

global $esynConfig;

$root = IA_URL;
$path = $root."plugins".IA_DS."banners".IA_DS."js".IA_DS."frontend".IA_DS."count-click.js";

echo "<script type=\"text/javascript\">";
echo "var root = '{$root}';";
echo "</script>";
echo "<script type=\"text/javascript\" src=\"{$path}\"></script>";

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

{if 'fancybox' == $config.lightbox_name}
	{ia_print_js files='plugins/fancybox/js/jquery.fancybox.pack'}

	{ia_add_js}
	$(document).ready(function()
	{
		$('a[rel^="ia_lightbox"]').fancybox(
		{
			nextEffect: '{$config.fancybox_slide_transition}',
			prevEffect: '{$config.fancybox_slide_transition}',
			openEffect: '{$config.fancybox_open_transition}',
			closeEffect: '{$config.fancybox_open_transition}',
			nextSpeed: '{$config.fancybox_slide_speed}',
			prevSpeed: '{$config.fancybox_slide_speed}',
			openSpeed: '{$config.fancybox_open_speed}',
			closeSpeed: '{$config.fancybox_open_speed}'
		});
	});
	{/ia_add_js}
{/if}

{$config.google_analytics}