Commercial and Domestic Cleaning company
This page uses Google Maps. The map will be loaded from Google-Server and some of your data may be used by Google. In order to see the maps, please click accept. You can also click here to see further information related to this.
In order to perform this action you have to login
In order to perform this action you have to login
This page uses Google Maps. The map will be loaded from Google-Server and some of your data may be used by Google. In order to see the maps, please click accept. You can also click here to see further information related to this.
SHOP LOCAL - Search here for your local businesses.
| Joomla! Version | 4.4.14 |
| PHP Version | 8.1.33 |
| Identity | guest |
| Response | 200 |
| Template | shaper_helixultimate |
| Database |
|
| 1 x afterRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (1.77MB) (43.4%) | 378.42ms |
| 1 x Before Access::preloadComponents (all components) (3.05MB) (17.4%) | 151.74ms |
| 1 x afterRender (1.67MB) (11.53%) | 100.55ms |
| 1 x beforeRenderRawModule mod_rssocial (Our Socials) (3.39MB) (6.58%) | 57.38ms |
| 1 x afterInitialise (1.94MB) (4.87%) | 42.50ms |
| 1 x beforeRenderRawModule mod_finder (Search) (433.13KB) (2.05%) | 17.86ms |
| 1 x afterRenderRawModule mod_rsform (Contact Us) (358.37KB) (1.6%) | 13.93ms |
| 1 x afterRoute (311.98KB) (1.53%) | 13.36ms |
| 1 x afterRenderRawModule mod_banners (Advertisers) (41.98KB) (1.5%) | 13.06ms |
| 1 x afterRenderRawModule mod_sppagebuilder (Footer) (62.58KB) (1.13%) | 9.89ms |
| 1 x afterRenderRawModule mod_articles_latest (Latest Releases) (67.52KB) (0.95%) | 8.28ms |
| 1 x afterRenderRawModule mod_finder (Search) (70.55KB) (0.77%) | 6.68ms |
| 1 x afterRenderComponent com_jbusinessdirectory (166.53KB) (0.72%) | 6.31ms |
| 1 x afterRenderRawModule mod_menu (Quick Links) (2.13KB) (0.59%) | 5.17ms |
| 1 x afterLoad (527.03KB) (0.58%) | 5.08ms |
| 1 x beforeRenderComponent com_jbusinessdirectory (109.16KB) (0.51%) | 4.48ms |
| 1 x afterRenderRawModule mod_menu (Menu) (7.47KB) (0.51%) | 4.46ms |
| 1 x afterDispatch (34.88KB) (0.43%) | 3.79ms |
| 1 x beforeRenderRawModule mod_custom (Privacy) (49.4KB) (0.41%) | 3.61ms |
| 1 x afterRenderRawModule mod_rssocial (Our Socials) (46.89KB) (0.37%) | 3.21ms |
| 1 x beforeRenderRawModule mod_articles_latest (Latest Releases) (7.3KB) (0.3%) | 2.62ms |
| 1 x afterRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (70.25KB) (0.26%) | 2.28ms |
| 1 x afterRenderRawModule mod_rssocial (Social Share) (12.23KB) (0.26%) | 2.23ms |
| 1 x beforeRenderRawModule mod_rsform (Contact Us) (18.52KB) (0.23%) | 1.96ms |
| 1 x beforeRenderRawModule mod_menu (Quick Links) (14.52KB) (0.2%) | 1.74ms |
| 1 x afterRenderRawModule mod_custom (Privacy) (4.23KB) (0.2%) | 1.71ms |
| 1 x After Access::preloadComponents (all components) (157.09KB) (0.12%) | 1.03ms |
| 1 x afterRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (101.93KB) (0.1%) | 862μs |
| 1 x afterRenderModule mod_sppagebuilder (Footer) (25.93KB) (0.09%) | 809μs |
| 1 x afterRenderModule mod_banners (Advertisers) (3.43KB) (0.08%) | 672μs |
| 1 x Before Access::getAssetRules (id:16 name:com_menus) (30.76KB) (0.08%) | 657μs |
| 1 x afterRenderModule mod_finder (Search) (3.62KB) (0.07%) | 640μs |
| 1 x afterRenderModule mod_rssocial (Social Share) (3.68KB) (0.06%) | 517μs |
| 1 x afterRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (45.93KB) (0.05%) | 458μs |
| 1 x beforeRenderRawModule mod_rssocial (Social Share) (33.6KB) (0.04%) | 387μs |
| 1 x afterRenderModule mod_menu (Menu) (3.18KB) (0.04%) | 329μs |
| 1 x afterRenderModule mod_rssocial (Our Socials) (3.27KB) (0.03%) | 256μs |
| 1 x beforeRenderRawModule mod_banners (Advertisers) (2.36KB) (0.03%) | 226μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (7.83KB) (0.02%) | 188μs |
| 1 x afterRenderModule mod_rsform (Contact Us) (4.46KB) (0.02%) | 185μs |
| 1 x afterRenderModule mod_articles_latest (Latest Releases) (2.71KB) (0.02%) | 171μs |
| 1 x afterRenderModule mod_custom (Privacy) (2.24KB) (0.02%) | 151μs |
| 1 x beforeRenderRawModule mod_sppagebuilder (Footer) (992B) (0.01%) | 130μs |
| 1 x afterRenderModule mod_menu (Quick Links) (3.21KB) (0.01%) | 125μs |
| 1 x beforeRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (7.73KB) (0.01%) | 105μs |
| 1 x beforeRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (11.45KB) (0.01%) | 91μs |
| 1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.01%) | 51μs |
| 1 x beforeRenderModule mod_rsform (Contact Us) (720B) (0.01%) | 45μs |
| 1 x beforeRenderModule mod_rssocial (Our Socials) (720B) (0%) | 38μs |
| 1 x beforeRenderRawModule mod_menu (Menu) (1.46KB) (0%) | 37μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (0%) | 36μs |
| 1 x beforeRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (752B) (0%) | 27μs |
| 1 x beforeRenderModule mod_sppagebuilder (Footer) (720B) (0%) | 26μs |
| 1 x beforeRenderModule mod_banners (Advertisers) (720B) (0%) | 20μs |
| 1 x beforeRenderModule mod_finder (Search) (704B) (0%) | 19μs |
| 1 x beforeRenderModule mod_articles_latest (Latest Releases) (720B) (0%) | 18μs |
| 1 x beforeRenderModule mod_custom (Privacy) (704B) (0%) | 15μs |
| 1 x beforeRenderModule mod_menu (Menu) (704B) (0%) | 10μs |
| 1 x beforeRenderModule mod_menu (Quick Links) (720B) (0%) | 10μs |
| 1 x beforeRenderModule mod_rssocial (Social Share) (720B) (0%) | 10μs |
| 1 x beforeRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (752B) (0%) | 10μs |
SELECT @@SESSION.sql_mode;214μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `jos_session`
WHERE `session_id` = ?490μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `jos_session`
WHERE `session_id` = :session_id LIMIT 1193μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)1.47ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1124μs18.48KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `jos_viewlevels`82μs1KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `jos_usergroups` AS `a`
LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest84μs1.64KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `jos_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`92μs4.8KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `jos_template_styles`
WHERE `client_id` = 0 AND `home` = 195μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1402CopySELECT *
FROM jos_rsform_config175μs1.75KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `jos_menu` AS `m`
LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`972μs20.73KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT fas.*
FROM jos_jbusinessdirectory_application_settings fas269μs81.05KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM jos_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'80μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM jos_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='47'71μs1KB/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM jos_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shangri-la-domestic-and-commercial-cleaning-limited' LIMIT 1977μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM `jos_jbusinessdirectory_companies` c where c.alias = 'shangri-la-domestic-and-commercial-cleaning-limited' LIMIT 1863μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181CopySELECT * FROM jos_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shangri-la-domestic-and-commercial-cleaning-limited' LIMIT 1121μs6.45KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM `jos_jbusinessdirectory_companies` c where c.alias = 'shangri-la-domestic-and-commercial-cleaning-limited' LIMIT 1489μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181CopySELECT *
FROM `jos_template_styles`
WHERE `client_id` = 0 AND `id` = '9'126μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:58CopySELECT *
FROM `jos_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC109μs2.22KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `jos_template_styles` AS `s`
LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1224μs41.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_default_attributes`1.7ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, name, listing_config as config FROM jos_jbusinessdirectory_default_attributes789μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_companies`1.58ms3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySET SESSION group_concat_max_len = 1000070μs0B/components/com_jbusinessdirectory/helpers/utils.php:6923Copyselect bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName, GROUP_CONCAT(DISTINCT ct.company_view separator ',') as companyView, cr.country_name,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',IFNULL(cg.icon,''),'|', IFNULL(cg.color,'') ORDER BY cg.lft separator '#|') as categories,
cr.country_name,GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures,
ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
from jos_jbusinessdirectory_companies bc
left join jos_jbusinessdirectory_company_types ct on find_in_set(ct.id,bc.typeId)
left join jos_jbusinessdirectory_company_category cc on bc.id=cc.companyId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId
left join jos_jbusinessdirectory_categories ccm on ccm.id=bc.mainSubcategory and ccm.published=1
left join jos_jbusinessdirectory_countries as cr on cr.id = bc.countryId
left join jos_jbusinessdirectory_company_pictures cpt on cpt.companyId=bc.id and cpt.picture_enable = 1
where bc.id=438 group by bc.id order by name1.96ms21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_packages`1.45ms2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect id, package_id from jos_jbusinessdirectory_companies where id= 438216μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from jos_jbusinessdirectory_packages p
left join jos_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=438
left join jos_jbusinessdirectory_package_fields pf on p.id=pf.package_id
where p.status=1 and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date) or p.expiration_type=1)
or
(now() between inv.start_trial_date and inv.end_trial_date)
)
))
)
or (
((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0)))
)
group by p.id
order by p.price desc, p.ordering desc2.29ms21.44KB/administrator/components/com_jbusinessdirectory/tables/package.php:261CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_providers`1.27ms2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from jos_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 438 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday459μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from jos_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 438 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday215μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_categories`1.23ms13.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_categories c
where c.id=878200μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from jos_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=438 ORDER BY ordering asc, name,path593μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copyselect * from jos_jbusinessdirectory_categories where published=1 order by lft, parent_id, name471μs75.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_attributes`1.73ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=438
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering919μs19.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_contact`1.23ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_contact where companyId=438 order by contact_department224μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copyselect * from jos_jbusinessdirectory_company_contact where companyId=438 order by contact_department51μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_testimonials`1.1ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_testimonials where companyId=438 order by testimonial_title206μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copyselect DISTINCT contact_department from jos_jbusinessdirectory_company_contact where companyId=438 order by contact_department146μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47CopySELECT *
FROM jos_jbusinessdirectory_company_pictures
WHERE picture_enable =1 and companyId =438
ORDER BY id293μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT *
FROM jos_jbusinessdirectory_company_pictures_extra
WHERE image_enable =1 and companyId =438
ORDER BY id143μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_videos`1.26ms1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_videos where companyId=438150μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_sounds`977μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_sounds where company_id= 438 order by id asc91μs960B/administrator/components/com_jbusinessdirectory/tables/companysounds.php:38CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_offers`1.2ms2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect co.id, co.price , co.specialPrice, co.subject, co.short_description, co.address, co.city, co.county, co.province, co.area, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.quantity, co.min_purchase, co.max_purchase,
op.picture_info,op.picture_path,op.picture_title, co.currencyId, co.price_text,co.time_zone, co.add_to_price_list, co.enable_offer_selling,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.name separator '#|') as categories,
GROUP_CONCAT(DISTINCT cg.id) as categoryIds,
sum(os.qty) as stock_quantity
from
jos_jbusinessdirectory_company_offers co
left join jos_jbusinessdirectory_company_offer_pictures op on co.id=op.offerId
and
(op.id in (
select min(op1.id) as min from jos_jbusinessdirectory_company_offers co1
left join jos_jbusinessdirectory_company_offer_pictures op1 on co1.id=op1.offerId
where op1.picture_enable=1
group by co1.id
)
)
left join jos_jbusinessdirectory_company_offer_category cc on co.id=cc.offerId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join jos_jbusinessdirectory_offer_stock as os on os.offer_id = co.id
where co.companyId=438 and co.state=1 and (co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) and (co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00'or co.publish_end_date is null)
and (co.approved = 0 or co.approved = 1) and co.item_type = 1 and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) and ((co.publish_start_date=DATE(now()) and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) and ((co.publish_end_date=DATE(now()) and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )
group by co.id, op.id
order by co.id desc7.05ms4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_events`6.85ms2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect co.*, op.picture_path, et.name as eventType, cg.markerLocation as categoryMarker
from jos_jbusinessdirectory_company_events co
left join jos_jbusinessdirectory_company_event_pictures op on co.id=op.eventId
and (op.id in (
select min(op1.id) as min from jos_jbusinessdirectory_company_events co1
left join jos_jbusinessdirectory_company_event_pictures op1 on co1.id=op1.eventId
where op1.picture_enable=1 and company_id=438
group by co1.id))
left join jos_jbusinessdirectory_company_event_types et on co.type=et.id
left join jos_jbusinessdirectory_company_event_category cc on co.id=cc.eventId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
where co.state=1 and (co.end_date>=DATE(now()) or co.end_date='0000-00-00') and company_id=438 and (co.approved = 0 or co.approved = 1)
group by co.id
order by co.start_date LIMIT 502.67ms8.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699CopySELECT id, name, event_config as config FROM jos_jbusinessdirectory_default_attributes90μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copyselect DISTINCT cp.* from jos_jbusinessdirectory_companies cp
left join jos_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join jos_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1)
left join jos_jbusinessdirectory_company_related rc on rc.related_company_id=cp.id
where rc.company_id=438 and (
(
(inv.state= 1 and (
(
(now() > (inv.start_date) and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1))
or
(now() > (inv.start_trial_date) and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY)))
))
)
or (
((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0)))
) and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) and cp.state = 1607μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1842CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_services_list`1.31ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_services_list where companyId=438 order by service_section, id138μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_event_associated_items`1.21ms1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect DISTINCT ce.*
from jos_jbusinessdirectory_company_events ce
left join jos_jbusinessdirectory_companies cp on cp.id = ce.company_id
left join jos_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join jos_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1)
WHERE ce.id IN (
select eac.event_id
from jos_jbusinessdirectory_company_events co
left join jos_jbusinessdirectory_company_event_associated_items eac
on eac.event_id=co.id where eac.company_id=438
) and ce.state = 1 and (ce.approved = 0 or ce.approved = 1) and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date) or p.expiration_type=1)
or
(now() between inv.start_trial_date and inv.end_trial_date)
)
))
)
or (
((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0)))
) and ce.end_date>= DATE(NOW()) LIMIT 50783μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235CopySELECT id, name, offer_config as config FROM jos_jbusinessdirectory_default_attributes109μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_memberships`1.24ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT c.*
FROM jos_jbusinessdirectory_memberships c
LEFT JOIN jos_jbusinessdirectory_company_membership cc ON c.id=cc.membership_id
WHERE company_id=438 AND c.status = 1 AND c.show_in_front = 1
ORDER BY c.type,c.name488μs1.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews`1.37ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect cr.*, scores, criteria_ids, answer_ids, question_ids from jos_jbusinessdirectory_company_reviews cr
left join (
select GROUP_CONCAT(ruc.score) as scores, GROUP_CONCAT(rc.id) as criteria_ids, r.id as cr_id
from jos_jbusinessdirectory_company_reviews r
left join jos_jbusinessdirectory_company_reviews_user_criteria ruc on r.id=ruc.review_id
left join jos_jbusinessdirectory_company_reviews_criteria rc on rc.id=ruc.criteria_id and rc.published =1
group by r.id
) rcs on cr.id = rcs.cr_id
left join (
select GROUP_CONCAT(rqa.id) as answer_ids, GROUP_CONCAT(rq.id) as question_ids, r.id as cr_id
from jos_jbusinessdirectory_company_reviews r
left join jos_jbusinessdirectory_company_reviews_question_answer rqa on r.id=rqa.review_id
left join jos_jbusinessdirectory_company_reviews_question rq on rq.id=rqa.question_id
group by r.id
) rqs on cr.id = rqs.cr_id
where 1 and cr.itemId=438 and cr.review_type =1 and state=1 and (cr.approved = 0 or cr.approved = 2)
order by creationDate desc LIMIT 101.89ms12.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copyselect cr.* from jos_jbusinessdirectory_company_reviews cr
where 1 and cr.itemId=438 and cr.review_type =1 and state=1 and (cr.approved = 0 or cr.approved = 2)469μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_criteria`899μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_reviews_criteria
where published = 153μs1.03KB/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_question`1.87ms1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect *
from jos_jbusinessdirectory_company_reviews_question
where 1 and published = 1
order by ordering64μs1.11KB/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:33CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_question_answer`1.05ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect rqa.*
from jos_jbusinessdirectory_company_reviews_question_answer rqa
left join jos_jbusinessdirectory_company_reviews cr on cr.id = rqa.review_id
where cr.itemId =438 and review_type = 1279μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_projects`1.07ms1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect co.*, GROUP_CONCAT( DISTINCT op.id,'|',op.projectId,'|',op.picture_info,'|',op.picture_path,'|',op.picture_enable ORDER BY op.id separator '#|') as pictures
from jos_jbusinessdirectory_company_projects co
left join jos_jbusinessdirectory_company_projects_pictures op on co.id=op.projectId and op.picture_enable = 1
where company_id=438 and status=1
group by co.id
order by co.id239μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_announcements`1.32ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT co.*,cp.name AS companyName
FROM jos_jbusinessdirectory_company_announcements co
LEFT JOIN jos_jbusinessdirectory_companies cp ON cp.id = co.company_id
WHERE co.status=1 AND cp.id=438 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00')
ORDER BY co.title272μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copyselect * from jos_jbusinessdirectory_company_claim where companyId = 438 and status <> -1 order by id desc278μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1370CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_articles`1.06ms1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect *
from jos_jbusinessdirectory_company_articles ca
inner join jos_content ct on ct.id = ca.article_id
where company_id=438 and ct.state = 1
order by ct.created desc282μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34CopySELECT id, name
FROM jos_jbusinessdirectory_companies as c
WHERE c.id != 438 AND c.state = 1
GROUP BY c.id
ORDER BY c.name ASC LIMIT 501.43ms1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3792CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_registered`1.23ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect DISTINCT cp.* from jos_jbusinessdirectory_companies cp
left join jos_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join jos_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1)
left join jos_jbusinessdirectory_company_registered rc on rc.joined_company_id=cp.id
where rc.company_id=438 and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date) or p.expiration_type=1)
or
(now() between inv.start_trial_date and inv.end_trial_date)
)
))
)
or (
((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0)))
) and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) and cp.state = 1 and rc.approved='2'863μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_members`1.15ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_members where company_id=438 order by id122μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copyupdate jos_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=438522μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1314CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_statistics`1.3ms1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_statistics`1.07ms1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyINSERT INTO `jos_jbusinessdirectory_statistics`
(`id`,`item_id`,`item_type`,`date`,`type`) VALUES
('0','438','1','2025-10-08 22:21:31','0')266μs0B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:817CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52,:preparedArray53)303μs8.25KBParams/libraries/src/Access/Access.php:357CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `jos_modules` AS `m`
LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`1.68ms34.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT folder.*
FROM `jos_eventgallery_folder` AS folder
LEFT JOIN `jos_eventgallery_file` AS file ON folder.folder = file.folder and file.published=1 and file.ismainimage=0
WHERE file.file IS NULL AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4 OR folder.foldertypeid=5)245μs7.05KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79CopySELECT `name`
FROM `jos_extensions`
WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'94μs840B/administrator/components/com_eventgallery/version.php:26CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `jos_categories` AS `c`
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1
ORDER BY `c`.`lft`231μs5.36KBParams/libraries/src/Categories/Categories.php:375CopySELECT `name`,`element`
FROM `jos_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1111μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `jos_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)63μs840B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT *
FROM `jos_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '228'376μs92.25KB/modules/mod_sppagebuilder/helper.php:49CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'96μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79CopySELECT enabled
FROM `jos_extensions`
WHERE `name` = 'com_easystore'72μs840B/administrator/components/com_sppagebuilder/editor/helpers/ApplicationHelper.php:138CopySELECT `template`
FROM `jos_template_styles`
WHERE `client_id` = 0 AND `home` = 153μs856B/components/com_sppagebuilder/builder/classes/base.php:88CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM jos_tags
WHERE `published` = '1') AS a
LEFT JOIN `jos_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC112μs1.13KB/components/com_sppagebuilder/builder/classes/base.php:374CopySELECT a.enabled
FROM `jos_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'53μs840B/components/com_sppagebuilder/builder/classes/base.php:973CopySELECT a.enabled
FROM `jos_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'88μs840B/components/com_sppagebuilder/builder/classes/base.php:973CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM jos_tags
WHERE `published` = '1') AS a
LEFT JOIN `jos_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC76μs1.13KB/components/com_sppagebuilder/builder/classes/base.php:374CopySELECT a.enabled
FROM `jos_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'53μs840B/components/com_sppagebuilder/builder/classes/base.php:973CopySELECT a.enabled
FROM `jos_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')161μs840B/components/com_sppagebuilder/builder/classes/base.php:866CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'151μs912B/components/com_sppagebuilder/helpers/helper.php:1780CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'155μs912B/components/com_sppagebuilder/helpers/helper.php:1780CopySELECT `a`.`name`,`a`.`css_path`
FROM `jos_sppagebuilder_assets` AS `a`
WHERE `a`.`published` = 178μs896B/components/com_sppagebuilder/helpers/helper.php:1809CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'585μs912B/components/com_sppagebuilder/helpers/helper.php:1780CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'103μs912B/components/com_sppagebuilder/helpers/helper.php:1780CopySELECT `template`
FROM `jos_template_styles`
WHERE `client_id` = 0 AND `home` = 1129μs856B/components/com_sppagebuilder/builder/classes/base.php:88CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jos_modules AS m
WHERE
(
(m.published = 1 AND m.id = 227) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0504μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:158CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jos_modules AS m
WHERE
(
(m.published = 1 AND m.id = 223) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0396μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:158CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`
FROM `jos_content` AS `a`
LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.publish_up DESC LIMIT 31.38ms24.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`171μs5.16KBParams/libraries/src/Categories/Categories.php:375CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jos_modules AS m
WHERE
(
(m.published = 1 AND m.id = 130) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0279μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:158CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jos_modules AS m
WHERE
(
(m.published = 1 AND m.id = 253) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0405μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:158CopySELECT *
FROM `jos_rsform_forms`
WHERE `FormId`='9'992μs21.41KB/administrator/components/com_rsform/helpers/rsform.php:3696CopySELECT `Lang`
FROM jos_rsform_forms
WHERE `FormId` = '9'44μs856B/administrator/components/com_rsform/helpers/rsform.php:3015CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (6) AND `FormId` = '9' AND `Published` = '1'68μs840B/administrator/components/com_rsform/helpers/rsform.php:1739CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (411) AND `FormId` = '9' AND `Published` = '1'49μs840B/administrator/components/com_rsform/helpers/rsform.php:1739CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (355) AND `FormId` = '9' AND `Published` = '1'46μs840B/administrator/components/com_rsform/helpers/rsform.php:1739CopySELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`Order`
FROM `jos_rsform_properties` AS `p`
LEFT JOIN `jos_rsform_components` AS `c` ON (`c`.`ComponentId` = `p`.`ComponentId`)
LEFT JOIN `jos_rsform_component_types` AS `ct` ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`)
WHERE `c`.`FormId` = '9' AND `p`.`PropertyName` = 'NAME' AND `c`.`Published` = '1'
ORDER BY `c`.`Order` ASC126μs1.11KB/administrator/components/com_rsform/helpers/rsform.php:2707CopySELECT `PropertyName`,`PropertyValue`,`ComponentId`
FROM `jos_rsform_properties`
WHERE `ComponentId` IN (51,52,54,55)69μs1.31KB/administrator/components/com_rsform/helpers/rsform.php:742CopySELECT `FormId`
FROM `jos_rsform_components`
WHERE `ComponentId`='51'53μs856B/administrator/components/com_rsform/helpers/rsform.php:757CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (14) AND `FormId` = '9' AND `Published` = '1'72μs840B/administrator/components/com_rsform/helpers/rsform.php:1739CopySHOW FULL COLUMNS FROM `jos_rsform_registration`1.34ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `jos_rsform_registration`
WHERE `form_id` = '9' AND `published` = '1'146μs3.73KB/libraries/src/Table/Table.php:755CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (41) AND `FormId` = '9' AND `Published` = '1'97μs16.82KB/administrator/components/com_rsform/helpers/rsform.php:1739CopySELECT `ComponentId`
FROM `jos_rsform_components`
WHERE `ComponentTypeId` IN (9) AND `FormId` = '9' AND `Published` = '1'78μs840B/administrator/components/com_rsform/helpers/rsform.php:1739CopySELECT `p`.`PropertyValue` AS `ComponentName`,`p`.`ComponentId`
FROM `jos_rsform_components` AS `c`
LEFT JOIN `jos_rsform_properties` AS `p` ON (`c`.`ComponentId`=`p`.`ComponentId`)
WHERE `c`.`FormId`='9' AND `p`.`PropertyName`='NAME' AND `c`.`Published` = '1'
ORDER BY `c`.`Order` ASC58μs960B/administrator/components/com_rsform/helpers/conditions.php:38CopySELECT *
FROM `jos_rsform_conditions`
WHERE `form_id` = '9' AND `lang_code` = 'en-GB'
ORDER BY `ordering` ASC63μs1.2KB/administrator/components/com_rsform/helpers/conditions.php:84CopySELECT *
FROM `jos_rsform_calculations`
WHERE `formId` = '9'
ORDER BY `ordering`60μs1.05KB/administrator/components/com_rsform/helpers/rsform.php:3663CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jos_modules AS m
WHERE
(
(m.published = 1 AND m.id = 222) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0474μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:158CopySELECT *
FROM `jos_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)675μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `jos_banners` AS `a`
LEFT JOIN `jos_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, RAND() LIMIT 11.87ms2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `jos_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)1.35ms856BParams/components/com_banners/src/Model/BannersModel.php:315CopyUPDATE `jos_banner_tracks`
SET `count` = `count` + 1
WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate760μs832BParams/components/com_banners/src/Model/BannersModel.php:352CopySELECT * FROM jos_jbusinessdirectory_categories
WHERE parent_id=1 AND published=1 AND type=1
ORDER BY lft172μs4.41KB/modules/mod_jbusiness_listings_search/helper.php:21CopySELECT c.* FROM jos_jbusinessdirectory_categories c
INNER JOIN jos_jbusinessdirectory_categories cc ON c.parent_id = cc.id
WHERE c.parent_id!=1 AND c.published=1 AND c.type=1
ORDER BY c.lft LIMIT 1000145μs23.95KB/modules/mod_jbusiness_listings_search/helper.php:31CopySELECT * FROM jos_jbusinessdirectory_company_types ORDER BY ordering ASC88μs1.42KB/modules/mod_jbusiness_listings_search/helper.php:40CopySELECT city, county
FROM jos_jbusinessdirectory_companies
WHERE state = 1 AND city != ''
ORDER BY county ASC1.11ms8.88KB/modules/mod_jbusiness_listings_search/helper.php:100CopySELECT DISTINCT city, city AS id FROM jos_jbusinessdirectory_companies
WHERE state = 1 AND city != ''
ORDER BY city ASC795μs1.06KB/modules/mod_jbusiness_listings_search/helper.php:56CopySET SQL_BIG_SELECTS=143μs0B/components/com_jbusinessdirectory/helpers/utils.php:6942Copyselect slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from (
select
cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name
from jos_jbusinessdirectory_companies cp
left join jos_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join jos_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and (cr.approved=2 OR cr.approved=0)
left join jos_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join jos_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join jos_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join jos_jbusinessdirectory_packages p on (inv.package_id=p.id and inv.state= 1 and (NOW() between inv.start_date and inv.end_date) and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1)
left join jos_jbusinessdirectory_package_fields pf on p.id=pf.package_id
left join jos_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.state=1 and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date))
or
(now() between inv.start_trial_date and inv.end_trial_date)
)
))
)
or (
(p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0))
)
and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
) as slec
where 1
having 1
order by featured desc LIMIT 150144ms68.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1122Copyselect slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from (
select
cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,
cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile,
cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,
cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,
cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,
cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,
cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.lft separator '#|') as categories,
GROUP_CONCAT( DISTINCT cg.id) as categoryIds,
GROUP_CONCAT(DISTINCT ct.name) as typeName,
bk.id as bookmark,
count(distinct cr.id) as nr_reviews,
cn.country_name as countryName
,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name
from jos_jbusinessdirectory_companies cp
left join jos_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join jos_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and (cr.approved=2 OR cr.approved=0)
left join jos_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join jos_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join jos_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join jos_jbusinessdirectory_packages p on (inv.package_id=p.id and inv.state= 1 and (NOW() between inv.start_date and inv.end_date) and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1)
left join jos_jbusinessdirectory_package_fields pf on p.id=pf.package_id
left join jos_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.id in (7,98,99,102,103,122,124,137,159,228,264,290,301,343,411,412,415,418,420,435,442,449,450,451,452,456,462,463,464,466,467,468,469,470,471,474,476,491,500,49,97,104,107,108,109,110,113,114,115,116,117,118,120,121,127,128,134,136,138,139,140,141,142,147,148,150,152,153,155,156,157,158,161,162,163,164,165,166,167,170,171,173,174,176,178,179,180,181,182,183,185,186,187,188,227,229,230,231,232,234,235,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,259,260,262,263,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,292)
group by cp.id
) as slec
where 1
order by featured desc132ms134.55KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering162μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=98
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering130μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=99
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=102
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering167μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=103
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering132μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=122
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=124
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=137
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering151μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=159
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=228
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=264
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering126μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=290
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=301
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering152μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=343
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering129μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=411
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering140μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=412
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering199μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=415
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering126μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=418
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=420
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering82μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=435
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering140μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=442
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=449
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering77μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=450
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=451
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=452
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=456
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=462
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering78μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=463
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=464
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=466
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering117μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=467
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=468
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=469
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=470
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering187μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=471
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=474
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering136μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=476
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=491
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering126μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=500
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering138μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=49
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering135μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=97
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering132μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=104
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=107
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=108
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering121μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=109
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering146μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=110
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=113
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=114
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering131μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=115
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=116
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=117
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=118
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=120
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=121
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=127
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=128
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering146μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=134
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=136
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=138
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=139
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=140
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=141
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering772μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=142
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering549μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=147
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering144μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=148
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering157μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=150
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering202μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=152
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering105μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=153
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=155
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=156
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=157
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=158
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=161
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering152μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=162
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering102μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=163
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=164
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=165
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=166
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=167
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=170
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=171
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=173
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=174
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=176
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=178
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=179
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=180
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=181
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=182
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=183
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=185
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=186
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering101μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=187
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=188
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=227
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=229
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=230
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=231
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering101μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=232
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=234
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=235
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=237
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=238
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=239
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=240
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=241
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering132μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=242
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=243
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=244
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering121μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=245
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=246
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs35.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=247
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=248
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=249
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=250
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering534μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=251
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=252
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering75μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=253
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering75μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=254
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=255
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=256
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=257
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=259
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering1.22ms3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=260
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=262
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=263
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=266
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=267
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering80μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=268
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=269
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=270
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=271
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=272
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=273
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering145μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=274
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=275
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=276
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=277
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=278
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=279
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=280
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering85μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=281
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering102μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=282
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=283
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=284
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering88μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=285
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=286
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=287
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=288
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=292
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52CopySELECT params
FROM `jos_template_styles`
WHERE `client_id` = 0 AND `home` = 1308μs40.84KB/plugins/system/sppagebuilder/sppagebuilder.php:2010CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'80μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `jos_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'49μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79CopySELECT *
FROM `jos_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'110μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `jos_gsd_config`1.43ms1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `jos_gsd_config`
WHERE `name` = 'config'96μs912B/libraries/src/Table/Table.php:755CopySELECT *
FROM `jos_jbusinessdirectory_companies`
WHERE `id` = '438'820μs20.78KB/libraries/src/Table/Table.php:755CopySELECT * FROM jos_jbusinessdirectory_company_pictures
WHERE companyId =438
ORDER BY id738μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM jos_jbusinessdirectory_company_pictures_extra
WHERE companyId =438
ORDER BY id202μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM jos_jbusinessdirectory_company_videos
WHERE companyId =438
ORDER BY id177μs1008B/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM jos_jbusinessdirectory_company_sounds
WHERE company_id =438
ORDER BY id109μs960B/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_zipcodes`1.13ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_zipcodes where company_id=438159μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyzipcode.php:30CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_city`905μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect ac.*, c.name, c.id from jos_jbusinessdirectory_company_activity_city ac
left join jos_jbusinessdirectory_cities c on ac.city_id=c.id
where company_id= 438169μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivitycity.php:48CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_region`1.04ms1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect ac.*, c.name, c.id from jos_jbusinessdirectory_company_activity_region ac
left join jos_jbusinessdirectory_regions c on ac.region_id=c.id
where company_id= 438167μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivityregion.php:49CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_country`1ms1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect ac.*, c.country_name as name, c.id from jos_jbusinessdirectory_company_activity_country ac
left join jos_jbusinessdirectory_countries c on ac.country_id=c.id
where company_id= 438133μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivitycountry.php:49Copyselect * from jos_jbusinessdirectory_company_contact where companyId=438 order by contact_department61μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_editors`1.17ms1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect ce.editor_id as value, concat(us.name,'-',us.username) AS name
from jos_jbusinessdirectory_company_editors as ce
left join jos_users as us on us.id = ce.editor_id
where company_id='438'276μs896B/administrator/components/com_jbusinessdirectory/tables/companyeditor.php:43CopySELECT a.id AS value, a.name AS text, a.username AS username
FROM `jos_users` AS a
ORDER BY a.name ASC80μs2.44KB/components/com_jbusinessdirectory/helpers/utils.php:6347Copyselect * from jos_jbusinessdirectory_company_testimonials where companyId=438 order by testimonial_title96μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_countries`1.65ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT * FROM jos_jbusinessdirectory_countries ORDER BY country_name176μs21.17KB/administrator/components/com_jbusinessdirectory/tables/country.php:41CopySELECT t.*
from jos_jbusinessdirectory_countries c
inner join jos_jbusinessdirectory_language_translations t on c.id=t.object_id where t.type=7 and language_tag='en-GB'102μs1.2KB/components/com_jbusinessdirectory/helpers/translations.php:486CopySELECT t.*
from jos_jbusinessdirectory_countries c
inner join jos_jbusinessdirectory_language_translations t on c.id=t.object_id where t.type=7 and language_tag='en-GB'77μs0B/components/com_jbusinessdirectory/helpers/translations.php:490CopySELECT c.* FROM jos_jbusinessdirectory_countries c
inner join jos_jbusinessdirectory_regions r on c.id = r.country_id
group by c.id
ORDER BY c.country_name84μs1.17KB/administrator/components/com_jbusinessdirectory/tables/country.php:60CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_types`1.07ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_company_types order by name104μs1.42KB/administrator/components/com_jbusinessdirectory/tables/companytypes.php:31CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_cities`903μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT * FROM jos_jbusinessdirectory_cities ORDER BY name102μs1.06KB/administrator/components/com_jbusinessdirectory/tables/city.php:57CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_regions`947μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT * FROM jos_jbusinessdirectory_regions ORDER BY name92μs1008B/administrator/components/com_jbusinessdirectory/tables/region.php:70CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_locations`1.33ms2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect a.*,b.country_name as country from jos_jbusinessdirectory_company_locations a
left join jos_jbusinessdirectory_countries b on a.countryId = b.id
where company_id=438280μs3.61KB/administrator/components/com_jbusinessdirectory/tables/companylocations.php:32Copyselect related_company_id
from jos_jbusinessdirectory_company_related rc
LEFT join jos_jbusinessdirectory_companies c on rc.company_id=c.id
where rc.company_id=438123μs840B/administrator/components/com_jbusinessdirectory/tables/company.php:1921CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_category`1.08ms1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect categoryId from jos_jbusinessdirectory_company_category cc inner join jos_jbusinessdirectory_categories c on cc.categoryId=c.id where companyId=438335μs856B/administrator/components/com_jbusinessdirectory/tables/companycategory.php:75Copyselect membership_id from jos_jbusinessdirectory_company_membership cc
inner join jos_jbusinessdirectory_memberships c on cc.membership_id=c.id
where company_id=438211μs840B/administrator/components/com_jbusinessdirectory/tables/memberships.php:44Copyselect * from jos_jbusinessdirectory_company_category cc inner join jos_jbusinessdirectory_categories c on cc.categoryId=c.id where companyId=438375μs4.03KB/administrator/components/com_jbusinessdirectory/tables/companycategory.php:68CopySELECT *
FROM `jos_jbusinessdirectory_packages`
WHERE `id` = '2'222μs23.91KB/libraries/src/Table/Table.php:755Copyselect feature from jos_jbusinessdirectory_package_fields where package_id= 2206μs968B/administrator/components/com_jbusinessdirectory/tables/package.php:170Copyselect * , inv.id as invoice_id, max(p.ordering)
from jos_jbusinessdirectory_packages p
left join jos_jbusinessdirectory_orders inv on p.id=inv.package_id
where p.status=1 and inv.company_id=438 and p.id=2
and inv.state = 1 and (inv.end_date > now() or inv.end_trial_date > now() or p.expiration_type=1)
group by p.id
order by p.price desc727μs20.77KB/administrator/components/com_jbusinessdirectory/tables/package.php:320Copyselect * , inv.id as invoice_id
from jos_jbusinessdirectory_packages p
left join jos_jbusinessdirectory_orders inv on p.id=inv.package_id
where p.status=1 and inv.company_id=438 and inv.state = 1
#group by inv.company_id
order by inv.id desc967μs20.73KB/administrator/components/com_jbusinessdirectory/tables/package.php:191Copyselect * , inv.id as invoice_id, max(p.ordering)
from jos_jbusinessdirectory_packages p
left join jos_jbusinessdirectory_orders inv on p.id=inv.package_id
where p.status=1 and inv.company_id=438 and inv.state = 1 and inv.amount > 0
group by inv.company_id
order by inv.id desc979μs20.77KB/administrator/components/com_jbusinessdirectory/tables/package.php:207Copyselect p.* , group_concat(pf.feature order by pf.id separator '#') as featuresS
from jos_jbusinessdirectory_packages p
left join jos_jbusinessdirectory_package_fields pf on p.id=pf.package_id
where 1 and p.status =1 and package_type = 1
group by p.id
order by p.ordering asc114μs23.97KB/administrator/components/com_jbusinessdirectory/tables/package.php:90Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from jos_jbusinessdirectory_attributes a
left join jos_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join jos_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join jos_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=438
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect * from jos_jbusinessdirectory_company_attachments where type=1 and object_id=438 ORDER BY ordering asc, name,path147μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copyselect * from jos_jbusinessdirectory_company_members where company_id=438 order by id49μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copyselect l.*, u.name from jos_jbusinessdirectory_logs l
left join jos_users u on l.user_id = u.id
where item_id = 438 and item_type=1
order by l.date desc357μs1.17KB/components/com_jbusinessdirectory/helpers/utils.php:9285CopySHOW FULL COLUMNS FROM `jos_jbusinessdirectory_currencies`1.05ms1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect * from jos_jbusinessdirectory_currencies where currency_id='47'60μs1KB/administrator/components/com_jbusinessdirectory/tables/currency.php:36Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from jos_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 438 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday81μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName, GROUP_CONCAT(DISTINCT ct.company_view separator ',') as companyView, cr.country_name,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',IFNULL(cg.icon,''),'|', IFNULL(cg.color,'') ORDER BY cg.lft separator '#|') as categories,
cr.country_name,GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures,
ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
from jos_jbusinessdirectory_companies bc
left join jos_jbusinessdirectory_company_types ct on find_in_set(ct.id,bc.typeId)
left join jos_jbusinessdirectory_company_category cc on bc.id=cc.companyId
left join jos_jbusinessdirectory_categories cg on cg.id=cc.categoryId
left join jos_jbusinessdirectory_categories ccm on ccm.id=bc.mainSubcategory and ccm.published=1
left join jos_jbusinessdirectory_countries as cr on cr.id = bc.countryId
left join jos_jbusinessdirectory_company_pictures cpt on cpt.companyId=bc.id and cpt.picture_enable = 1
where bc.id=438 group by bc.id order by name1.22ms21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from jos_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 438 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday86μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect * from jos_jbusinessdirectory_categories c
where c.id=87888μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySELECT a.*
FROM jos_gsd a
WHERE a.state = 1 AND a.plugin = 'jbusinessdirectory' AND a.appview IN ('companies','*')
ORDER BY a.id desc77μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT a.*
FROM jos_gsd a
WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*')
ORDER BY a.id desc123μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `jos_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1411μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `alias`
FROM `jos_content`
WHERE `id` = :id150μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`309μs5.16KBParams/libraries/src/Categories/Categories.php:375CopySELECT `alias`
FROM `jos_content`
WHERE `id` = :id68μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `jos_content`
WHERE `id` = :id70μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`157μs5.16KBParams/libraries/src/Categories/Categories.php:375CopySELECT `alias`
FROM `jos_content`
WHERE `id` = :id64μs1.63KBParams/components/com_content/src/Service/Router.php:168CopySELECT `session_id`
FROM `jos_session`
WHERE `session_id` = ?344μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `jos_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?1.55ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
Shangri-La Domestic and Commercial Cleaning Limited
Commercial and Domestic Cleaning company