Warning (2): Trying to access array offset on value of type bool [APP/Plugin/Classified/Controller/ClassifiedsController.php, line 1248]

        $type = (isset($this->viewVars['type']) ? $this->viewVars['type'] : 'all');
        $url = $type;
        $params = array('type' => 'all', 'user_id' => $viewer['User']['id'], 'search_location' => 0);

ClassifiedsController::search() - APP/Plugin/Classified/Controller/ClassifiedsController.php, line 1248
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 80

Warning (2): Trying to access array offset on value of type null [APP/Plugin/Classified/Controller/ClassifiedsController.php, line 1248]

Code Context

        $type = (isset($this->viewVars['type']) ? $this->viewVars['type'] : 'all');
        $url = $type;
        $params = array('type' => 'all', 'user_id' => $viewer['User']['id'], 'search_location' => 0);

ClassifiedsController::search() - APP/Plugin/Classified/Controller/ClassifiedsController.php, line 1248
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 80

Found 6 listings

Show map

Scratch Tree Climbing Tree XXL Cat Tree Sisal Cat Scratch Tree for Cats Featured

Pets - Feandrea

4850 W Powell Rd, Powell, OH 43065, United States

$49.99

ã€Quality Materialsã€‘The multi-level cat tower is composed of good quality particle board, ... View More >>

Kids 2 Level Wooden Colourful Car Garage Floor City Park Toy Playset With 2 Cars

Kids toy - Marionette

Montreal, Canada

$25.12

Keep your little ones entertained for hours with this beautiful, colourful, wooden garage plays... View More >>

River's End 8097-BK Microfleece Jacket Mens Athletic - Black Featured

Men - Microfleece

3031 New Castle Ave, New Castle, DE 19720, United States

$75

Microfleece Jacket 8097-BK 75.00 Â Product Details 100% polyester anti-pill micro... View More >>

2023 NEW ISSEY MIYAKE FASHION TEE TOP COAT Sponsored

Woman - MIYAKE

1500 S Capitol St SE, Washington, DC 20003, United States

$29.99

Size: One sizeRear middle length; 57cmbust; 98cmSleeve length; 40cm View More >>

Leica M4-2 Post Camera very RARE with 2/35mm Summicron Featured

Camera - Leica

Avenida Fundidora y, 64010 Monterrey, N.L., Mexico

$4921

Leica M4-2 Post Camera very RARE with 2/35mm Summicron the rarest version of all L... View More >>

BORN PRETTY 7ML Jelly Nude Gel Polish Translucent Pink UV LED Soak Off Gel Nail Featured

Woman - BORN PRETTY

1801 Mountain Rd NW, Albuquerque, NM 87104, United States

$2.22

Specification:Brand: BORN PRETTYÂ Â Â Â Â Â Â Â Â Â Type: Gel PolishColorï¼š As the pictures sho... View More >>

(default) 75 queries took 26 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '7e3f0002aa6db0ea636a650ab02e42f4' LIMIT 1	1	1	0
2	SELECT Classified., User.,ClassifiedCategory.,( 3959 acos( cos( radians(0) ) * cos( radians( Classified.lat ) ) * cos( radians(Classified.lng) - radians(0)) + sin(radians(0)) * sin( radians(Classified.lat)))) AS distance, `Classified`.`id` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`state` = 2 ORDER BY `Classified`.`id` DESC LIMIT 10	6	6	1
3	SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc	1	1	1
4	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC	3	3	1
5	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`parent_id` = 0 ORDER BY `ClassifiedCategory`.`order` ASC	10	10	1
6	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (22, 18, 15, 6, 10, 5, 4, 3, 2, 1) ORDER BY `id` ASC	30	30	1
7	SELECT `ClassifiedPaymentmethod`.`id`, `ClassifiedPaymentmethod`.`name`, `ClassifiedPaymentmethod`.`classified_count`, `ClassifiedPaymentmethod`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedPaymentmethod__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_paymentmethods` AS `ClassifiedPaymentmethod` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedPaymentmethod`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedPaymentmethod' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `ClassifiedPaymentmethod`.`order` ASC	4	4	1
8	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_paymentmethod_id` IN (1, 2, 3, 4)	10	10	1
9	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedPaymentmethod' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4) ORDER BY `id` ASC	12	12	0
10	SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1	1	1	0
11	SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC	4	4	0
12	SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC	12	12	1
13	SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC	0	0	0
14	SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC	0	0	1
15	SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC	0	0	1
16	SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC	0	0	1
17	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 25 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	1
18	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (25) ORDER BY `id` ASC	3	3	0
19	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 11 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
20	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (11)	1	1	0
21	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (11) ORDER BY `id` ASC	3	3	0
22	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 11 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
23	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (11)	1	1	0
24	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (11) ORDER BY `id` ASC	3	3	0
25	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
26	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 16 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	0
27	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (16) ORDER BY `id` ASC	3	3	1
28	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 10 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	1
29	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (10)	1	1	0
30	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (10) ORDER BY `id` ASC	3	3	0
31	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 10 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
32	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (10)	1	1	0
33	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (10) ORDER BY `id` ASC	3	3	0
34	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
35	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 8 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	1
36	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (8) ORDER BY `id` ASC	3	3	0
37	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 8 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	1
38	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (8)	1	1	0
39	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (8) ORDER BY `id` ASC	3	3	0
40	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 8 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	1
41	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (8)	1	1	0
42	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (8) ORDER BY `id` ASC	3	3	0
43	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
44	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	0
45	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC	3	3	0
46	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 7 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
47	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (7)	1	1	0
48	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC	3	3	0
49	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 7 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
50	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (7)	1	1	0
51	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC	3	3	0
52	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
53	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 12 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	4
54	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (12) ORDER BY `id` ASC	3	3	0
55	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 5 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
56	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (5)	1	1	0
57	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (5) ORDER BY `id` ASC	3	3	1
58	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 5 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
59	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (5)	1	1	1
60	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (5) ORDER BY `id` ASC	3	3	2
61	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
62	SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1	1	1	1
63	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC	3	3	0
64	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 4 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
65	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (4)	1	1	0
66	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC	3	3	0
67	SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 4 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1	1	1	0
68	SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_brand_id` = (4)	1	1	0
69	SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC	3	3	0
70	SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1	1	1	0
71	SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1	1	1	0
72	SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1	1	1	0
73	SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1	1	1	0
74	SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1	1	1	0
75	SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1	1	1	0

(default) 75 queries took 26 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '7e3f0002aa6db0ea636a650ab02e42f4' LIMIT 1

SELECT Classified.*, User.*,ClassifiedCategory.*,( 3959 * acos( cos( radians(0) ) * cos( radians( Classified.lat ) ) * cos( radians(Classified.lng) - radians(0)) + sin(radians(0)) * sin( radians(Classified.lat)))) AS distance, `Classified`.`id` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`state` = 2 ORDER BY `Classified`.`id` DESC LIMIT 10

SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`parent_id` = 0 ORDER BY `ClassifiedCategory`.`order` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (22, 18, 15, 6, 10, 5, 4, 3, 2, 1) ORDER BY `id` ASC

SELECT `ClassifiedPaymentmethod`.`id`, `ClassifiedPaymentmethod`.`name`, `ClassifiedPaymentmethod`.`classified_count`, `ClassifiedPaymentmethod`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedPaymentmethod__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_paymentmethods` AS `ClassifiedPaymentmethod` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedPaymentmethod`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedPaymentmethod' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `ClassifiedPaymentmethod`.`order` ASC

SELECT `Classified`.`id`, `Classified`.`user_id`, `Classified`.`available`, `Classified`.`status`, `Classified`.`featured`, `Classified`.`sponsored`, `Classified`.`classified_category_id`, `Classified`.`classified_package_id`, `Classified`.`classified_brand_id`, `Classified`.`classified_paymentmethod_id`, `Classified`.`state`, `Classified`.`condition`, `Classified`.`delivery_method`, `Classified`.`number_available`, `Classified`.`name`, `Classified`.`description`, `Classified`.`price`, `Classified`.`location`, `Classified`.`lat`, `Classified`.`lng`, `Classified`.`thumbnail`, `Classified`.`created`, `Classified`.`modified`, `Classified`.`recently_view`, `Classified`.`privacy`, `Classified`.`classified_contact_count`, `Classified`.`review_rating`, `Classified`.`review_count`, `Classified`.`view_count`, `Classified`.`share_count`, `Classified`.`like_count`, `Classified`.`comment_count`, `Classified`.`dislike_count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` WHERE `Classified`.`classified_paymentmethod_id` IN (1, 2, 3, 4)

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedPaymentmethod' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4) ORDER BY `id` ASC

SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1

SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC

SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC

SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 25 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (25) ORDER BY `id` ASC

SELECT `ClassifiedBrand`.`id`, `ClassifiedBrand`.`name`, `ClassifiedBrand`.`classified_count`, `ClassifiedBrand`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedBrand__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedBrand`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedBrand' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedBrand`.`id` = 11 ORDER BY `ClassifiedBrand`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (11) ORDER BY `id` ASC

SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `travel_moosocial`.`qccurrencies` AS `Currency` WHERE `Currency`.`currency_code` = 'USD' LIMIT 1

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 16 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (16) ORDER BY `id` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (10) ORDER BY `id` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 8 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (8) ORDER BY `id` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (8) ORDER BY `id` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 12 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (12) ORDER BY `id` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (5) ORDER BY `id` ASC

SELECT `ClassifiedCategory`.`id`, `ClassifiedCategory`.`parent_id`, `ClassifiedCategory`.`lft`, `ClassifiedCategory`.`rght`, `ClassifiedCategory`.`name`, `ClassifiedCategory`.`classified_count`, `ClassifiedCategory`.`order`, (`I18n__nameTranslation`.`content`) AS `ClassifiedCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ClassifiedCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ClassifiedCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ClassifiedCategory`.`id` = 7 ORDER BY `ClassifiedCategory`.`order` ASC LIMIT 1

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC

SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ClassifiedBrand' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC

SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1

SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1

Search

Found 6 listings