Businesses

Show map
(default) 133 queries took 69 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `plpb_strascity`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1111
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `plpb_strascity`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'ba844fea1e7cf4a2a7dff8c82346c3da' LIMIT 1001
3SELECT `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, (`I18n__titleTranslation`.`content`) AS `Page__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Page__i18n_contentTranslation`, `MyCoreTheme`.`id`, `MyCoreTheme`.`key`, `MyCoreTheme`.`name`, `MyCoreTheme`.`core`, `MyCoreTheme`.`custom_css_enable`, `MyCoreTheme`.`custom_css` FROM `plpb_strascity`.`pages` AS `Page` LEFT JOIN `plpb_strascity`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) INNER JOIN `plpb_strascity`.`i18n` AS `I18n__titleTranslation` ON (`Page`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Page' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'fra') INNER JOIN `plpb_strascity`.`i18n` AS `I18n__contentTranslation` ON (`Page`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Page' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'fra') WHERE `Page`.`uri` = 'business.search' ORDER BY `Page`.`weight` asc LIMIT 1112
4SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, `CoreContent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (110)11111
5SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
6SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
7SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
8SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
9SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
10SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
11SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
12SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
13SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
14SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
15SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `plpb_strascity`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 110110
16SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 248110
17SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 249110
18SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 251110
19SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 250110
20SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 248110
21SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 249110
22SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 251110
23SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin`, `Children`.`role_access` FROM `plpb_strascity`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (248, 249, 250, 251, 280, 282, 284, 286, 281, 283, 285)771
24SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (248, 249, 250, 251, 280, 282, 284, 286, 281, 283, 285) ORDER BY `id` ASC22221
25SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (110) ORDER BY `id` ASC220
26SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (110) ORDER BY `id` ASC221
27SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
28SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
29SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` IS NULL LIMIT 1000
30SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `plpb_strascity`.`businesses` AS `Business` WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0 ORDER BY `Business`.`featured` DESC LIMIT 1010101
31SELECT COUNT(*) AS `count` FROM `plpb_strascity`.`businesses` AS `Business` WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0110
32SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
33SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1111
34SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 1110
35SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
36SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
37SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
38SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 2110
39SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
40SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
41SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
42SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 3220
43SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` IN (3, 6) ORDER BY `BusinessCategory`.`ordering` ASC221
44SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
45SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1111
46SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 4110
47SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
48SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
49SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
50SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 5110
51SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
52SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
53SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
54SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 6110
55SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
56SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
57SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
58SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 7110
59SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
60SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
61SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1111
62SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 8110
63SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (7) ORDER BY `BusinessCategory`.`ordering` ASC111
64SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
65SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1111
66SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 9110
67SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (9) ORDER BY `BusinessCategory`.`ordering` ASC111
68SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `plpb_strascity`.`users` AS `User` LEFT JOIN `plpb_strascity`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `plpb_strascity`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1111
69SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `plpb_strascity`.`business_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1111
70SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 10110
71SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`id` = (9) ORDER BY `BusinessCategory`.`ordering` ASC111
72SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 1 LIMIT 1110
73SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
74SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
75SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 2 LIMIT 1110
76SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
77SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
78SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 3 LIMIT 1110
79SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 3 LIMIT 1110
80SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 17 AND `BusinessCategory`.`rght` >= 18 ORDER BY `BusinessCategory`.`lft` asc111
81SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 4 LIMIT 1110
82SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
83SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
84SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 5 LIMIT 1110
85SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
86SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
87SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 6 LIMIT 1110
88SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
89SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
90SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 7 LIMIT 1110
91SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
92SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
93SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 8 LIMIT 1110
94SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 7 LIMIT 1110
95SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 22 AND `BusinessCategory`.`rght` >= 23 ORDER BY `BusinessCategory`.`lft` asc221
96SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 9 LIMIT 1110
97SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 9 LIMIT 1110
98SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 26 AND `BusinessCategory`.`rght` >= 27 ORDER BY `BusinessCategory`.`lft` asc221
99SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `plpb_strascity`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 10 LIMIT 1110
100SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 9 LIMIT 1110
101SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 26 AND `BusinessCategory`.`rght` >= 27 ORDER BY `BusinessCategory`.`lft` asc221
102SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `plpb_strascity`.`business_categories` AS `BusinessCategory` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'fra') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 0 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10991
103SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
104SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
105SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
106SELECT `BusinessLocation`.`id` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC000
107SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `plpb_strascity`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IS NULL ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
108SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1110
109SELECT `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 `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
110SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `plpb_strascity`.`core_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1111
111SELECT `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` FROM `plpb_strascity`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC21211
112SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (27, 19, 37, 35, 36, 38, 39, 41, 26, 21, 22, 23, 8, 32, 18, 17, 20, 29, 33, 6, 34) ORDER BY `id` ASC42421
113SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC001
114SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 19 AND `is_active` = '1' ORDER BY `menu_order` ASC771
115SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (37, 39, 41, 26, 21, 22, 23) ORDER BY `id` ASC14141
116SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 37 AND `is_active` = '1' ORDER BY `menu_order` ASC331
117SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (35, 36, 38) ORDER BY `id` ASC661
118SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 35 AND `is_active` = '1' ORDER BY `menu_order` ASC001
119SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 36 AND `is_active` = '1' ORDER BY `menu_order` ASC001
120SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 38 AND `is_active` = '1' ORDER BY `menu_order` ASC001
121SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 39 AND `is_active` = '1' ORDER BY `menu_order` ASC001
122SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 41 AND `is_active` = '1' ORDER BY `menu_order` ASC001
123SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC001
124SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC001
125SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 18 AND `is_active` = '1' ORDER BY `menu_order` ASC001
126SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 20 AND `is_active` = '1' ORDER BY `menu_order` ASC441
127SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `plpb_strascity`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (29, 33, 6, 34) ORDER BY `id` ASC881
128SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 29 AND `is_active` = '1' ORDER BY `menu_order` ASC001
129SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC001
130SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 6 AND `is_active` = '1' ORDER BY `menu_order` ASC001
131SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `plpb_strascity`.`core_menu_items` AS `Coremenuitem` INNER JOIN `plpb_strascity`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'fra') WHERE `parent_id` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC001
132SELECT `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 `plpb_strascity`.`settings` AS `Setting` LEFT JOIN `plpb_strascity`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1111
133SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `plpb_strascity`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1110