Welcome to Bicester

Poundland

1616
QR code VCard
https://beautifulbicester.co.uk/components/com_jbusinessdirectory/assets/no_image.jpg
Poundland
  • Bicester
Categories:

Is this your business?

Claim listing is the best way to manage and protect your business

Claim Business
  • Details
Type
Retailer
Business location has not been defined
Espresso Architecture

Bicester Business Directory Log on

Add listing

Menu

J! InfoRequestSessionProfileQueries367
15.284MBMemory Usage689msRequest Duration
Joomla! Version4.4.13
PHP Version8.1.33
Identityguest
Response200
Templateshaper_helixultimate
Database
Server
mysql
Version
10.6.22-MariaDB-cll-lve
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:65 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1758043428 "last" => 1758043428...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
company_yelp_id
""
  • afterLoad (527.03KB) (2.85ms)
  • afterInitialise (1.94MB) (34.97ms)
  • afterRoute (311.71KB) (11.8ms)
  • beforeRenderComponent com_jbusinessdirectory (109.16KB) (4.79ms)
  • Before Access::preloadComponents (all components) (3.04MB) (114ms)
  • After Access::preloadComponents (all components) (157.09KB) (910μs)
  • Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (35μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.83KB) (206μs)
  • afterRenderComponent com_jbusinessdirectory (177.38KB) (6.42ms)
  • afterDispatch (37.09KB) (3.06ms)
  • beforeRenderRawModule mod_finder (Search) (432.59KB) (15.55ms)
  • afterRenderRawModule mod_finder (Search) (70.55KB) (5.7ms)
  • beforeRenderModule mod_finder (Search) (704B) (14μs)
  • afterRenderModule mod_finder (Search) (3.62KB) (670μs)
  • Before Access::getAssetRules (id:16 name:com_menus) (30.76KB) (647μs)
  • After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (45μs)
  • beforeRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (7.73KB) (111μs)
  • afterRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (68.77KB) (2.38ms)
  • beforeRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (752B) (9μs)
  • afterRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (45.93KB) (450μs)
  • beforeRenderRawModule mod_menu (Menu) (1.46KB) (39μs)
  • afterRenderRawModule mod_menu (Menu) (7.47KB) (4.74ms)
  • beforeRenderModule mod_menu (Menu) (704B) (9μs)
  • afterRenderModule mod_menu (Menu) (3.18KB) (376μs)
  • beforeRenderRawModule mod_sppagebuilder (Footer) (992B) (88μs)
  • beforeRenderRawModule mod_rssocial (Our Socials) (3.28MB) (39.82ms)
  • afterRenderRawModule mod_rssocial (Our Socials) (45.64KB) (1.32ms)
  • beforeRenderModule mod_rssocial (Our Socials) (720B) (7μs)
  • afterRenderModule mod_rssocial (Our Socials) (3.27KB) (106μs)
  • beforeRenderRawModule mod_articles_latest (Latest Releases) (7.3KB) (1.2ms)
  • afterRenderRawModule mod_articles_latest (Latest Releases) (76.64KB) (4.66ms)
  • beforeRenderModule mod_articles_latest (Latest Releases) (720B) (9μs)
  • afterRenderModule mod_articles_latest (Latest Releases) (2.71KB) (77μs)
  • beforeRenderRawModule mod_menu (Quick Links) (14.52KB) (1.01ms)
  • afterRenderRawModule mod_menu (Quick Links) (2.13KB) (3.1ms)
  • beforeRenderModule mod_menu (Quick Links) (720B) (6μs)
  • afterRenderModule mod_menu (Quick Links) (3.21KB) (48μs)
  • beforeRenderRawModule mod_rsform (Contact Us) (18.52KB) (1.04ms)
  • afterRenderRawModule mod_rsform (Contact Us) (350.37KB) (10.41ms)
  • beforeRenderModule mod_rsform (Contact Us) (720B) (13μs)
  • afterRenderModule mod_rsform (Contact Us) (4.46KB) (94μs)
  • beforeRenderRawModule mod_custom (Privacy) (49.4KB) (2.02ms)
  • afterRenderRawModule mod_custom (Privacy) (4.23KB) (895μs)
  • beforeRenderModule mod_custom (Privacy) (704B) (7μs)
  • afterRenderModule mod_custom (Privacy) (2.24KB) (55μs)
  • afterRenderRawModule mod_sppagebuilder (Footer) (62.58KB) (7.25ms)
  • beforeRenderModule mod_sppagebuilder (Footer) (720B) (18μs)
  • afterRenderModule mod_sppagebuilder (Footer) (25.93KB) (561μs)
  • beforeRenderRawModule mod_banners (Advertisers) (2.36KB) (132μs)
  • afterRenderRawModule mod_banners (Advertisers) (41.98KB) (6.32ms)
  • beforeRenderModule mod_banners (Advertisers) (720B) (12μs)
  • afterRenderModule mod_banners (Advertisers) (3.43KB) (445μs)
  • beforeRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (11.45KB) (87μs)
  • afterRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (1.77MB) (321ms)
  • beforeRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (752B) (14μs)
  • afterRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (97.93KB) (464μs)
  • beforeRenderRawModule mod_rssocial (Social Share) (33.6KB) (245μs)
  • afterRenderRawModule mod_rssocial (Social Share) (11.98KB) (1.26ms)
  • beforeRenderModule mod_rssocial (Social Share) (720B) (7μs)
  • afterRenderModule mod_rssocial (Social Share) (3.43KB) (246μs)
  • afterRender (1.66MB) (74.41ms)
  • 1 x afterRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (1.77MB) (46.62%)
    321.40ms
    1 x Before Access::preloadComponents (all components) (3.04MB) (16.48%)
    113.63ms
    1 x afterRender (1.66MB) (10.79%)
    74.41ms
    1 x beforeRenderRawModule mod_rssocial (Our Socials) (3.28MB) (5.78%)
    39.82ms
    1 x afterInitialise (1.94MB) (5.07%)
    34.97ms
    1 x beforeRenderRawModule mod_finder (Search) (432.59KB) (2.26%)
    15.55ms
    1 x afterRoute (311.71KB) (1.71%)
    11.80ms
    1 x afterRenderRawModule mod_rsform (Contact Us) (350.37KB) (1.51%)
    10.41ms
    1 x afterRenderRawModule mod_sppagebuilder (Footer) (62.58KB) (1.05%)
    7.25ms
    1 x afterRenderComponent com_jbusinessdirectory (177.38KB) (0.93%)
    6.42ms
    1 x afterRenderRawModule mod_banners (Advertisers) (41.98KB) (0.92%)
    6.32ms
    1 x afterRenderRawModule mod_finder (Search) (70.55KB) (0.83%)
    5.70ms
    1 x beforeRenderComponent com_jbusinessdirectory (109.16KB) (0.69%)
    4.79ms
    1 x afterRenderRawModule mod_menu (Menu) (7.47KB) (0.69%)
    4.74ms
    1 x afterRenderRawModule mod_articles_latest (Latest Releases) (76.64KB) (0.68%)
    4.66ms
    1 x afterRenderRawModule mod_menu (Quick Links) (2.13KB) (0.45%)
    3.10ms
    1 x afterDispatch (37.09KB) (0.44%)
    3.06ms
    1 x afterLoad (527.03KB) (0.41%)
    2.85ms
    1 x afterRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (68.77KB) (0.35%)
    2.38ms
    1 x beforeRenderRawModule mod_custom (Privacy) (49.4KB) (0.29%)
    2.02ms
    1 x afterRenderRawModule mod_rssocial (Our Socials) (45.64KB) (0.19%)
    1.32ms
    1 x afterRenderRawModule mod_rssocial (Social Share) (11.98KB) (0.18%)
    1.26ms
    1 x beforeRenderRawModule mod_articles_latest (Latest Releases) (7.3KB) (0.17%)
    1.20ms
    1 x beforeRenderRawModule mod_rsform (Contact Us) (18.52KB) (0.15%)
    1.04ms
    1 x beforeRenderRawModule mod_menu (Quick Links) (14.52KB) (0.15%)
    1.01ms
    1 x After Access::preloadComponents (all components) (157.09KB) (0.13%)
    910μs
    1 x afterRenderRawModule mod_custom (Privacy) (4.23KB) (0.13%)
    895μs
    1 x afterRenderModule mod_finder (Search) (3.62KB) (0.1%)
    670μs
    1 x Before Access::getAssetRules (id:16 name:com_menus) (30.76KB) (0.09%)
    647μs
    1 x afterRenderModule mod_sppagebuilder (Footer) (25.93KB) (0.08%)
    561μs
    1 x afterRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (97.93KB) (0.07%)
    464μs
    1 x afterRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (45.93KB) (0.07%)
    450μs
    1 x afterRenderModule mod_banners (Advertisers) (3.43KB) (0.06%)
    445μs
    1 x afterRenderModule mod_menu (Menu) (3.18KB) (0.05%)
    376μs
    1 x afterRenderModule mod_rssocial (Social Share) (3.43KB) (0.04%)
    246μs
    1 x beforeRenderRawModule mod_rssocial (Social Share) (33.6KB) (0.04%)
    245μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.83KB) (0.03%)
    206μs
    1 x beforeRenderRawModule mod_banners (Advertisers) (2.36KB) (0.02%)
    132μs
    1 x beforeRenderRawModule mod_jbusiness_user (Bicester Business Directory Log on) (7.73KB) (0.02%)
    111μs
    1 x afterRenderModule mod_rssocial (Our Socials) (3.27KB) (0.02%)
    106μs
    1 x afterRenderModule mod_rsform (Contact Us) (4.46KB) (0.01%)
    94μs
    1 x beforeRenderRawModule mod_sppagebuilder (Footer) (992B) (0.01%)
    88μs
    1 x beforeRenderRawModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (11.45KB) (0.01%)
    87μs
    1 x afterRenderModule mod_articles_latest (Latest Releases) (2.71KB) (0.01%)
    77μs
    1 x afterRenderModule mod_custom (Privacy) (2.24KB) (0.01%)
    55μs
    1 x afterRenderModule mod_menu (Quick Links) (3.21KB) (0.01%)
    48μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_menu (Menu) (1.46KB) (0.01%)
    39μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (0.01%)
    35μs
    1 x beforeRenderModule mod_sppagebuilder (Footer) (720B) (0%)
    18μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    14μs
    1 x beforeRenderModule mod_jbusiness_listings_search (JBusinessDirectory Listing Search) (752B) (0%)
    14μs
    1 x beforeRenderModule mod_rsform (Contact Us) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_banners (Advertisers) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_jbusiness_user (Bicester Business Directory Log on) (752B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Menu) (704B) (0%)
    9μs
    1 x beforeRenderModule mod_articles_latest (Latest Releases) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_rssocial (Our Socials) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_rssocial (Social Share) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Privacy) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Quick Links) (720B) (0%)
    6μs
367 statements were executed, 47 of which were duplicates, 320 unique347ms2.02MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7Duplicates 8Duplicates 9Duplicates 10Duplicates 11Duplicates 12Duplicates 13Duplicates 14Duplicates 15Duplicates 16Duplicates 17Duplicates 18Duplicates 19
  • SELECT @@SESSION.sql_mode;132μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?266μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1107μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.16ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1117μs18.48KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`69μs1KB/libraries/src/Access/Access.php:955Copy
  • SELECT `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` = :guest73μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `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`119μs4.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 172μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1403Copy
  • SELECT * FROM jos_rsform_config111μs1.75KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `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`628μs20.73KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_jbusinessdirectory_application_settings fas203μs81.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM jos_jbusinessdirectory_date_formats fas WHERE fas.id ='2'2.69ms1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM jos_jbusinessdirectory_currencies fas WHERE fas.currency_id ='47'73μs1KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM jos_jbusinessdirectory_categories c where c.type=1 and c.alias = 'poundland' LIMIT 1324μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `jos_jbusinessdirectory_companies` c where c.alias = 'poundland' LIMIT 1510μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SELECT * FROM jos_jbusinessdirectory_categories c where c.type=1 and c.alias = 'poundland' LIMIT 1134μs6.45KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `jos_jbusinessdirectory_companies` c where c.alias = 'poundland' LIMIT 1199μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '9'148μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:58Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC97μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `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` = 1205μs41.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_default_attributes`1.07ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id, name, listing_config as config FROM jos_jbusinessdirectory_default_attributes152μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_companies`1.15ms3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SET SESSION group_concat_max_len = 1000072μs0B/components/com_jbusinessdirectory/helpers/utils.php:6923Copy
  • select 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=257 group by bc.id order by name975μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_packages`1.03ms2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select id, package_id from jos_jbusinessdirectory_companies where id= 257189μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , 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=257 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 desc1.95ms21.44KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_providers`894μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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 = 257 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select 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 = 257 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday80μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_categories`886μs13.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_categories c where c.id=218118μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • select * from jos_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=257 ORDER BY ordering asc, name,path190μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copy
  • select * from jos_jbusinessdirectory_categories where published=1 order by lft, parent_id, name235μs75.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_attributes`816μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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.ordering166μs19.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_contact`1.28ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_contact where companyId=257 order by contact_department275μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • select * from jos_jbusinessdirectory_company_contact where companyId=257 order by contact_department77μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_testimonials`1.04ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_testimonials where companyId=257 order by testimonial_title209μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copy
  • select DISTINCT contact_department from jos_jbusinessdirectory_company_contact where companyId=257 order by contact_department273μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47Copy
  • SELECT * FROM jos_jbusinessdirectory_company_pictures WHERE picture_enable =1 and companyId =257 ORDER BY id653μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_jbusinessdirectory_company_pictures_extra WHERE image_enable =1 and companyId =257 ORDER BY id208μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_videos`1.06ms1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_videos where companyId=257192μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_sounds`1.1ms1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_sounds where company_id= 257 order by id asc189μs960B/administrator/components/com_jbusinessdirectory/tables/companysounds.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_offers`1.39ms2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 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 desc905μs4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_events`1.3ms2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 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=257 and (co.approved = 0 or co.approved = 1) group by co.id order by co.start_date LIMIT 501.7ms8.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699Copy
  • SELECT id, name, event_config as config FROM jos_jbusinessdirectory_default_attributes104μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • select 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=257 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 = 1572μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1842Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_services_list`1.16ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_services_list where companyId=257 order by service_section, id135μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_event_associated_items`986μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 ) 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 50610μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235Copy
  • SELECT id, name, offer_config as config FROM jos_jbusinessdirectory_default_attributes69μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_memberships`1.08ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT c.* FROM jos_jbusinessdirectory_memberships c LEFT JOIN jos_jbusinessdirectory_company_membership cc ON c.id=cc.membership_id WHERE company_id=257 AND c.status = 1 AND c.show_in_front = 1 ORDER BY c.type,c.name175μs1.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews`1.08ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 and cr.review_type =1 and state=1 and (cr.approved = 0 or cr.approved = 2) order by creationDate desc LIMIT 101.52ms12.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copy
  • select cr.* from jos_jbusinessdirectory_company_reviews cr where 1 and cr.itemId=257 and cr.review_type =1 and state=1 and (cr.approved = 0 or cr.approved = 2)171μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_criteria`973μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_reviews_criteria where published = 153μs1.03KB/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_question`1.02ms1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_reviews_question where 1 and published = 1 order by ordering57μs1.11KB/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:33Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_reviews_question_answer`1.16ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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 =257 and review_type = 1325μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_projects`1.07ms1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 and status=1 group by co.id order by co.id161μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_announcements`1.07ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT 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=257 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00') ORDER BY co.title209μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copy
  • select * from jos_jbusinessdirectory_company_claim where companyId = 257 and status <> -1 order by id desc227μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1370Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_articles`841μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_articles ca inner join jos_content ct on ct.id = ca.article_id where company_id=257 and ct.state = 1 order by ct.created desc243μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34Copy
  • SELECT id, name FROM jos_jbusinessdirectory_companies as c WHERE c.id != 257 AND c.state = 1 GROUP BY c.id ORDER BY c.name ASC LIMIT 501.34ms1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3792Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_registered`947μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257 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'789μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_members`910μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_members where company_id=257 order by id114μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copy
  • update jos_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=257985μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1314Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_statistics`936μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_statistics`867μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • INSERT INTO `jos_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) VALUES ('0','257','1','2025-09-16 17:23:48','0')274μs0B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:817Copy
  • SELECT `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)201μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `alias` FROM `jos_jbusinessdirectory_companies` WHERE id = '257'273μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT `alias` FROM `jos_jbusinessdirectory_companies` WHERE id = '257'55μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT `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`842μs34.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT 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)175μs7.05KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79Copy
  • SELECT `name` FROM `jos_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'71μs840B/administrator/components/com_eventgallery/version.php:26Copy
  • SELECT `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`177μs5.36KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 169μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)62μs840B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM `jos_sppagebuilder` WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '228'162μs92.25KB/modules/mod_sppagebuilder/helper.php:49Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'58μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:80Copy
  • SELECT enabled FROM `jos_extensions` WHERE `name` = 'com_easystore'56μs840B/administrator/components/com_sppagebuilder/editor/helpers/ApplicationHelper.php:138Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 141μs856B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT 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 ASC94μs1.13KB/components/com_sppagebuilder/builder/classes/base.php:373Copy
  • SELECT a.enabled FROM `jos_extensions` AS `a` WHERE `a`.`name` = 'com_k2'42μs840B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT a.enabled FROM `jos_extensions` AS `a` WHERE `a`.`name` = 'com_k2'41μs840B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT 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 ASC85μs1.13KB/components/com_sppagebuilder/builder/classes/base.php:373Copy
  • SELECT a.enabled FROM `jos_extensions` AS `a` WHERE `a`.`name` = 'com_k2'34μs840B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT a.enabled FROM `jos_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')67μs840B/components/com_sppagebuilder/builder/classes/base.php:865Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'61μs912B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'38μs912B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT `a`.`name`,`a`.`css_path` FROM `jos_sppagebuilder_assets` AS `a` WHERE `a`.`published` = 136μs896B/components/com_sppagebuilder/helpers/helper.php:1809Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'37μs912B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'35μs912B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 133μs856B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT 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 = 0237μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT 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 = 0215μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT `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 3817μs24.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `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`133μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT 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 = 0199μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT 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 = 0199μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT * FROM `jos_rsform_forms` WHERE `FormId`='9'224μs21.41KB/administrator/components/com_rsform/helpers/rsform.php:3696Copy
  • SELECT `Lang` FROM jos_rsform_forms WHERE `FormId` = '9'33μs856B/administrator/components/com_rsform/helpers/rsform.php:3015Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (6) AND `FormId` = '9' AND `Published` = '1'77μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (411) AND `FormId` = '9' AND `Published` = '1'39μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (355) AND `FormId` = '9' AND `Published` = '1'37μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SELECT `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` ASC63μs1.11KB/administrator/components/com_rsform/helpers/rsform.php:2707Copy
  • SELECT `PropertyName`,`PropertyValue`,`ComponentId` FROM `jos_rsform_properties` WHERE `ComponentId` IN (51,52,54,55)55μs1.31KB/administrator/components/com_rsform/helpers/rsform.php:742Copy
  • SELECT `FormId` FROM `jos_rsform_components` WHERE `ComponentId`='51'61μs856B/administrator/components/com_rsform/helpers/rsform.php:757Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (14) AND `FormId` = '9' AND `Published` = '1'33μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SHOW FULL COLUMNS FROM `jos_rsform_registration`1.2ms18.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_rsform_registration` WHERE `form_id` = '9' AND `published` = '1'114μs3.73KB/libraries/src/Table/Table.php:755Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (41) AND `FormId` = '9' AND `Published` = '1'64μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SELECT `ComponentId` FROM `jos_rsform_components` WHERE `ComponentTypeId` IN (9) AND `FormId` = '9' AND `Published` = '1'53μs840B/administrator/components/com_rsform/helpers/rsform.php:1739Copy
  • SELECT `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` ASC67μs960B/administrator/components/com_rsform/helpers/conditions.php:38Copy
  • SELECT * FROM `jos_rsform_conditions` WHERE `form_id` = '9' AND `lang_code` = 'en-GB' ORDER BY `ordering` ASC50μs1.2KB/administrator/components/com_rsform/helpers/conditions.php:84Copy
  • SELECT * FROM `jos_rsform_calculations` WHERE `formId` = '9' ORDER BY `ordering`49μs1.05KB/administrator/components/com_rsform/helpers/rsform.php:3663Copy
  • SELECT 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 = 0217μs2.03KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT * FROM `jos_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)362μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `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.2ms2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `jos_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)1.02ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • UPDATE `jos_banner_tracks` SET `count` = `count` + 1 WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate588μs832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • SELECT * FROM jos_jbusinessdirectory_categories WHERE parent_id=1 AND published=1 AND type=1 ORDER BY lft123μs4.41KB/modules/mod_jbusiness_listings_search/helper.php:21Copy
  • SELECT 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 1000132μs23.95KB/modules/mod_jbusiness_listings_search/helper.php:31Copy
  • SELECT * FROM jos_jbusinessdirectory_company_types ORDER BY ordering ASC88μs1.36KB/modules/mod_jbusiness_listings_search/helper.php:40Copy
  • SELECT city, county FROM jos_jbusinessdirectory_companies WHERE state = 1 AND city != '' ORDER BY county ASC717μs8.88KB/modules/mod_jbusiness_listings_search/helper.php:100Copy
  • SELECT DISTINCT city, city AS id FROM jos_jbusinessdirectory_companies WHERE state = 1 AND city != '' ORDER BY city ASC597μs1.06KB/modules/mod_jbusiness_listings_search/helper.php:56Copy
  • SET SQL_BIG_SELECTS=130μs0B/components/com_jbusinessdirectory/helpers/utils.php:6942Copy
  • select 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 150122ms68.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1122Copy
  • select 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,313,343,410,411,412,415,418,420,435,442,449,450,451,452,456,462,463,464,466,467,468,469,470,471,474,476,491,49,97,104,107,108,109,110,113,114,115,116,117,118,119,120,121,125,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) group by cp.id ) as slec where 1 order by featured desc127ms134.55KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
  • select 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.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering79μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering82μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering85μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering81μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering67μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering65μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering67μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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=313 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:52Copy
  • select 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.ordering72μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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=410 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:52Copy
  • select 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.ordering106μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering75μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering84μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering77μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering83μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering81μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering81μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering82μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering84μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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:52Copy
  • select 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.ordering73μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering73μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering84μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering138μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering74μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering66μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering83μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering82μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering67μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering68μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering74μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering72μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering78μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering72μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering79μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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=119 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:52Copy
  • select 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.ordering68μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering68μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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=125 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering71μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering80μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering78μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering74μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering76μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering59μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering60μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering60μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering59μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering85μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering88μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering67μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering75μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering89μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering88μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering73μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering168μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering423μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering71μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering148μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering79μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering106μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering729μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering191μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering65μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering195μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering73μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering65μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering61μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering70μs35.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering61μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering59μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering61μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering60μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering60μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering65μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering58μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering61μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering68μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering62μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering63μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering65μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering66μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering87μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering78μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering80μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering80μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering83μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering85μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering86μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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:52Copy
  • select 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.ordering80μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering77μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering69μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select 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.ordering69μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SELECT params FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 172μs40.84KB/plugins/system/sppagebuilder/sppagebuilder.php:1768Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'40μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:80Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jos_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'38μs912B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:80Copy
  • SELECT * FROM `jos_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'96μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `jos_gsd_config`925μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_gsd_config` WHERE `name` = 'config'66μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `jos_jbusinessdirectory_companies` WHERE `id` = '257'359μs20.78KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM jos_jbusinessdirectory_company_pictures WHERE companyId =257 ORDER BY id141μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_jbusinessdirectory_company_pictures_extra WHERE companyId =257 ORDER BY id87μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_jbusinessdirectory_company_videos WHERE companyId =257 ORDER BY id138μs1008B/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_jbusinessdirectory_company_sounds WHERE company_id =257 ORDER BY id63μs960B/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_zipcodes`947μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_zipcodes where company_id=25780μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyzipcode.php:30Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_city`864μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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= 257100μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivitycity.php:48Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_region`857μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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= 25791μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivityregion.php:49Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_activity_country`816μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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= 25790μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companyactivitycountry.php:49Copy
  • select * from jos_jbusinessdirectory_company_contact where companyId=257 order by contact_department57μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_editors`807μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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='257'146μs896B/administrator/components/com_jbusinessdirectory/tables/companyeditor.php:43Copy
  • SELECT a.id AS value, a.name AS text, a.username AS username FROM `jos_users` AS a ORDER BY a.name ASC58μs2.44KB/components/com_jbusinessdirectory/helpers/utils.php:6347Copy
  • select * from jos_jbusinessdirectory_company_testimonials where companyId=257 order by testimonial_title50μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_countries`877μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM jos_jbusinessdirectory_countries ORDER BY country_name134μs21.17KB/administrator/components/com_jbusinessdirectory/tables/country.php:41Copy
  • SELECT 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'56μs1.2KB/components/com_jbusinessdirectory/helpers/translations.php:486Copy
  • SELECT 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'45μs0B/components/com_jbusinessdirectory/helpers/translations.php:490Copy
  • SELECT 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_name42μs1.17KB/administrator/components/com_jbusinessdirectory/tables/country.php:60Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_types`884μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_company_types order by name57μs1.36KB/administrator/components/com_jbusinessdirectory/tables/companytypes.php:31Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_cities`835μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM jos_jbusinessdirectory_cities ORDER BY name51μs1.06KB/administrator/components/com_jbusinessdirectory/tables/city.php:57Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_regions`837μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM jos_jbusinessdirectory_regions ORDER BY name42μs1008B/administrator/components/com_jbusinessdirectory/tables/region.php:70Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_locations`855μs2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select 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=257147μs3.61KB/administrator/components/com_jbusinessdirectory/tables/companylocations.php:32Copy
  • select 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=25776μs840B/administrator/components/com_jbusinessdirectory/tables/company.php:1921Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_company_category`740μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select categoryId from jos_jbusinessdirectory_company_category cc inner join jos_jbusinessdirectory_categories c on cc.categoryId=c.id where companyId=257146μs856B/administrator/components/com_jbusinessdirectory/tables/companycategory.php:75Copy
  • select membership_id from jos_jbusinessdirectory_company_membership cc inner join jos_jbusinessdirectory_memberships c on cc.membership_id=c.id where company_id=257104μs840B/administrator/components/com_jbusinessdirectory/tables/memberships.php:44Copy
  • select * from jos_jbusinessdirectory_company_category cc inner join jos_jbusinessdirectory_categories c on cc.categoryId=c.id where companyId=257211μs4.03KB/administrator/components/com_jbusinessdirectory/tables/companycategory.php:68Copy
  • SELECT * FROM `jos_jbusinessdirectory_packages` WHERE `id` = '2'117μs23.91KB/libraries/src/Table/Table.php:755Copy
  • select feature from jos_jbusinessdirectory_package_fields where package_id= 232μs968B/administrator/components/com_jbusinessdirectory/tables/package.php:170Copy
  • select * , 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=257 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 desc392μs20.77KB/administrator/components/com_jbusinessdirectory/tables/package.php:320Copy
  • select * , 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=257 and inv.state = 1 #group by inv.company_id order by inv.id desc353μs20.73KB/administrator/components/com_jbusinessdirectory/tables/package.php:191Copy
  • select * , 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=257 and inv.state = 1 and inv.amount > 0 group by inv.company_id order by inv.id desc330μs20.77KB/administrator/components/com_jbusinessdirectory/tables/package.php:207Copy
  • select 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 asc105μs23.97KB/administrator/components/com_jbusinessdirectory/tables/package.php:90Copy
  • select 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.ordering64μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select * from jos_jbusinessdirectory_company_attachments where type=1 and object_id=257 ORDER BY ordering asc, name,path157μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copy
  • select * from jos_jbusinessdirectory_company_members where company_id=257 order by id40μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copy
  • select l.*, u.name from jos_jbusinessdirectory_logs l left join jos_users u on l.user_id = u.id where item_id = 257 and item_type=1 order by l.date desc327μs1.17KB/components/com_jbusinessdirectory/helpers/utils.php:9285Copy
  • SHOW FULL COLUMNS FROM `jos_jbusinessdirectory_currencies`1.15ms1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_jbusinessdirectory_currencies where currency_id='47'77μs1KB/administrator/components/com_jbusinessdirectory/tables/currency.php:36Copy
  • select 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 = 257 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday62μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select 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=257 group by bc.id order by name1.03ms21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • select 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 = 257 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday95μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select * from jos_jbusinessdirectory_categories c where c.id=21889μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • SELECT a.* FROM jos_gsd a WHERE a.state = 1 AND a.plugin = 'jbusinessdirectory' AND a.appview IN ('companies','*') ORDER BY a.id desc67μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM jos_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc57μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT 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` = 1220μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id113μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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`194μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id49μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id59μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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`141μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id61μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?227μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.44ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy