Results 1 - 88 of 88
In order to perform this action you have to login
In order to perform this action you have to login
| Joomla! Version | 5.2.2 |
| PHP Version | 8.1.32 |
| Identity | guest |
| Response | 200 |
| Template | j-directory |
| Database |
|
| 1 x afterRenderComponent com_jbusinessdirectory (10.23MB) (49.28%) | 274ms |
| 1 x afterInitialise (3.78MB) (28.84%) | 160ms |
| 1 x beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (7.85%) | 43.58ms |
| 1 x afterLoad (414.6KB) (7.76%) | 43.09ms |
| 1 x afterRender (1020.18KB) (2.46%) | 13.67ms |
| 1 x afterRoute (810.58KB) (2.2%) | 12.21ms |
| 1 x afterRenderRawModule mod_menu (Main Menu) (77.56KB) (0.62%) | 3.46ms |
| 1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.43%) | 2.41ms |
| 1 x afterDispatch (3.21KB) (0.23%) | 1.29ms |
| 1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.12%) | 670μs |
| 1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 8μs |
SELECT @@SESSION.sql_mode;71μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `brew_session`
WHERE `session_id` = ?7.69ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = :session_id LIMIT 185μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `brew_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)8.75ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `brew_viewlevels`93μs1.56KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `brew_usergroups` AS `a`
LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest144μs1.63KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'cparams'386μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `brew_admintools_wafexceptions`68μs960B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'188μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'142μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT *
FROM `brew_admintools_ipautoban`256μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126CopySELECT `ip`
FROM `brew_admintools_ipblock`66μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136CopySELECT *
FROM `brew_admintools_storage`
WHERE `key` LIKE 'timestamp_%'78μs912B/plugins/system/admintools/src/Feature/Base.php:255CopySELECT `source`,`dest`,`keepurlparams`
FROM `brew_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC90μs960B/plugins/system/admintools/src/Utility/Cache.php:162CopySELECT fas.*
FROM brew_jbusinessdirectory_application_settings fas252μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM brew_jbusinessdirectory_date_formats fas
WHERE fas.id ='3'65μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM brew_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'73μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'montana-breweries' LIMIT 1154μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `brew_admintools_wafblacklists`
WHERE `enabled` = 186μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'106μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'montana-breweries' LIMIT 1143μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM brew_jbusinessdirectory_mobile_app_config139μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`225μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes88μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`452μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`258μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_categories c
where c.id=241129μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name348μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copyinsert into brew_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values
('2','1','2025-04-13','241','0')1.15ms0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copyselect * from brew_jbusinessdirectory_categories c
where c.id=24195μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name283μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=123μs0B/components/com_jbusinessdirectory/helpers/utils.php:6906Copyselect * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id
left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join brew_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)
where 1 and cc.categoryId in (241,241) 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.state=1 and (cp.approved = 2 or cp.approved= -1) 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
having 1
) s
where 11.92ms13.48KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156CopySET SESSION group_concat_max_len = 1000017μs0B/components/com_jbusinessdirectory/helpers/utils.php:6887Copyselect 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 brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join brew_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id
left join brew_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join brew_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join brew_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 brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id
left join brew_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 cc.categoryId in (241,241) 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) 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, packageOrder desc, companyName asc LIMIT 10011.92ms19.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1122Copyselect slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from (
select
cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,
cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile,
cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,
cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,
cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,
cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,
cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.lft separator '#|') as categories,
GROUP_CONCAT( DISTINCT cg.id) as categoryIds,
bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker,bcm.icon as mainCategoryIcon, bcm.iconImgLocation as categoryIconImage, bcm.id as mainCategoryId,
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 l.latitude,'|',l.longitude,'|',l.street_number,'|',l.address,'|',l.city,'|',l.county,'|',l.postalCode,'|',l.phone,'|',l.province,'|',l.area separator '#') as locations
,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name
from brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join brew_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id
left join brew_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join brew_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id
left join brew_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 brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id
left join brew_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 (9165,9408,6033,6076,6246,6363,6407,15620,6494,6524,6528,6533,15621,6661,15622,6707,6725,6756,6762,15623,6862,6908,7024,7119,7140,7147,7159,7190,7215,14581,15624,15625,7551,7742,7847,8043,14579,15626,8246,8356,8443,8491,8559,8561,9484,8718,15627,15628,8871,8894,8920,14583,14584,9090,9170,9290,9322,9443,9486,9522,14578,9582,9628,15629,15630,15631,9920,16981,10026,15632,10179,10273,15633,15634,10769,15635,14580,11075,15636,11110,11163,14582,11300,11384,15637,11602,11653,11744)
group by cp.id
) as slec
where 1
order by featured desc, packageOrder desc, companyName asc4.99ms54.02KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`325μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9165 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday221μs2.23KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9165 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`179μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9165
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`281μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 916576μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9165
left join brew_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 = 4 and p.price=0)))
)
group by p.id
order by p.price desc, p.ordering desc678μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9408 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday160μs2.23KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9408 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9408
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 940868μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9408
left join brew_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 = 4 and p.price=0)))
)
group by p.id
order by p.price desc, p.ordering desc566μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6033 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday133μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6033 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday128μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6033
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 603360μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6033
left join brew_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 desc513μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6076 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday135μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6076 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6076
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 607653μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6076
left join brew_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 desc501μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6246 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday118μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6246 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday125μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6246
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 624654μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6246
left join brew_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 desc481μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6363 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs10.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6363 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6363
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 636352μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6363
left join brew_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 desc502μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6407 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6407 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday134μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6407
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 640756μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6407
left join brew_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 desc511μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15620 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15620 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15620
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering105μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562056μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15620
left join brew_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 desc490μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6494 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday158μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6494 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6494
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering99μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 649467μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6494
left join brew_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 desc512μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6524 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6524 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6524
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 652465μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6524
left join brew_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 desc821μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6528 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday125μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6528 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday127μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6528
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 652854μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6528
left join brew_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 desc549μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6533 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6533 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday117μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6533
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 653355μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6533
left join brew_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 desc539μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15621 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15621 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday116μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15621
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562155μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15621
left join brew_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 desc508μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6661 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday128μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6661 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6661
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 666151μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6661
left join brew_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 desc522μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15622 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15622 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday147μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15622
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562251μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15622
left join brew_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 desc529μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6707 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6707 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6707
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 670773μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6707
left join brew_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 desc502μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6725 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6725 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6725
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 672551μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6725
left join brew_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 desc532μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6756 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday118μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6756 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6756
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 675653μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6756
left join brew_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 desc524μs37.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6762 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday158μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6762 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6762
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 676256μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6762
left join brew_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 desc530μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15623 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday135μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15623 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15623
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562354μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15623
left join brew_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 desc494μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6862 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday144μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6862 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday118μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6862
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 686251μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6862
left join brew_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 desc517μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6908 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 6908 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday135μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6908
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 690852μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6908
left join brew_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 desc512μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7024 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7024 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7024
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 702462μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7024
left join brew_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 desc491μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7119 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7119 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7119
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 711951μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7119
left join brew_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 desc528μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7140 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7140 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7140
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 714053μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7140
left join brew_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 desc510μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7147 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7147 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7147
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 714753μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7147
left join brew_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 desc538μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7159 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7159 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7159
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 715957μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7159
left join brew_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 desc499μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7190 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7190 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7190
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 719051μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7190
left join brew_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 desc523μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7215 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7215 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday108μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7215
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 721552μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7215
left join brew_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 desc560μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14581 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14581 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14581
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1458168μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14581
left join brew_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 desc496μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15624 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15624 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15624
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562451μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15624
left join brew_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 desc522μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15625 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15625 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15625
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:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562550μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15625
left join brew_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 desc510μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7551 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7551 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7551
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 755153μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7551
left join brew_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 desc485μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7742 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7742 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7742
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 774252μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7742
left join brew_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 desc529μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7847 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday125μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 7847 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7847
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering98μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 784758μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7847
left join brew_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 desc507μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8043 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8043 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday113μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8043
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 804354μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8043
left join brew_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 desc524μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14579 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14579 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday116μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14579
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1457956μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14579
left join brew_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 desc506μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15626 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15626 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15626
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562651μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15626
left join brew_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 desc517μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8246 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8246 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8246
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 824654μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8246
left join brew_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 desc493μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8356 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8356 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8356
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 835655μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8356
left join brew_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 desc507μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8443 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8443 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday118μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8443
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 844352μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8443
left join brew_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 desc520μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8491 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8491 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday110μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8491
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering110μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 849152μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8491
left join brew_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 desc509μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8559 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8559 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8559
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 855957μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8559
left join brew_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 desc507μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8561 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8561 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8561
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs35.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 856150μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8561
left join brew_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 desc518μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9484 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9484 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9484
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 948493μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9484
left join brew_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 desc508μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8718 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8718 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday117μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8718
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 871877μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8718
left join brew_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 desc493μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15627 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15627 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15627
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering104μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562752μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15627
left join brew_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 desc512μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15628 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15628 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15628
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562851μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15628
left join brew_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 desc526μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8871 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday119μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8871 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday109μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8871
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 887156μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8871
left join brew_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 desc521μs37.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8894 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8894 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8894
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 889461μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8894
left join brew_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 desc541μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8920 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 8920 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8920
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 892055μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8920
left join brew_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 desc506μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14583 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14583 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday112μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14583
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1458355μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14583
left join brew_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 desc513μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14584 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14584 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday117μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14584
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1458454μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14584
left join brew_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 desc524μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9090 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9090 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9090
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 909060μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9090
left join brew_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 desc506μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9170 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9170 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday111μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9170
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 917053μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9170
left join brew_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 desc493μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9290 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9290 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday113μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9290
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 929054μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9290
left join brew_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 desc510μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9322 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9322 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9322
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 932254μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9322
left join brew_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 desc508μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9443 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9443 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9443
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 944352μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9443
left join brew_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 desc526μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9486 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9486 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday113μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9486
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 948652μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9486
left join brew_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 desc553μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9522 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9522 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday128μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9522
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 952255μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9522
left join brew_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 desc511μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14578 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday125μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14578 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14578
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1457878μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14578
left join brew_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 desc482μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9582 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:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9582 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday116μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9582
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 958250μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9582
left join brew_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 desc511μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9628 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9628 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday146μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9628
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering95μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 962852μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9628
left join brew_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 desc521μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15629 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday127μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15629 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday109μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15629
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1562980μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15629
left join brew_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 desc500μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15630 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15630 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday113μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15630
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering100μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563051μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15630
left join brew_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 desc538μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15631 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday134μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15631 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday127μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15631
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563152μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15631
left join brew_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 desc514μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9920 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 9920 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday128μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9920
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 992052μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9920
left join brew_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 desc544μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 16981 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday128μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 16981 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=16981
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1698157μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=16981
left join brew_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 desc493μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10026 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday149μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10026 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10026
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering101μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1002658μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10026
left join brew_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 desc507μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15632 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday150μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15632 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15632
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering101μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563257μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15632
left join brew_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 desc600μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10179 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10179 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10179
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1017957μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10179
left join brew_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 desc522μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10273 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10273 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10273
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:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1027361μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10273
left join brew_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 desc523μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15633 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday135μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15633 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday117μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15633
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering97μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563366μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15633
left join brew_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 desc547μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15634 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday141μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15634 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday118μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15634
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering105μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563472μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15634
left join brew_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 desc553μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10769 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 10769 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10769
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1076953μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10769
left join brew_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 desc518μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15635 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15635 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday145μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15635
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering96μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563554μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15635
left join brew_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 desc517μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14580 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14580 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14580
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering118μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1458055μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14580
left join brew_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 desc504μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11075 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday132μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11075 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11075
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1107556μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11075
left join brew_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 desc496μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15636 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15636 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15636
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563662μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15636
left join brew_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 desc531μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11110 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday124μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11110 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday109μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11110
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1111061μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11110
left join brew_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 desc499μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11163 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11163 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday115μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11163
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering90μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1116352μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11163
left join brew_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 desc538μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14582 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday129μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 14582 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14582
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:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1458254μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=14582
left join brew_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 desc519μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11300 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday122μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11300 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday114μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11300
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1130052μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11300
left join brew_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 desc512μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11384 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday123μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11384 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday116μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11384
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering103μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1138468μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11384
left join brew_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 desc490μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15637 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday127μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 15637 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday126μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15637
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering92μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1563751μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15637
left join brew_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 desc514μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11602 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday121μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11602 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday113μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11602
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering94μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1160252μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11602
left join brew_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 desc533μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11653 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday120μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11653 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday110μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11653
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering91μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1165364μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11653
left join brew_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 desc492μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11744 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,
GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
from brew_jbusinessdirectory_company_provider_hours as cph
where cph.provider_id = 11744 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect a.*,
GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options,
GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS,
GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons,
at.code as attributeTypeCode,
GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue
from brew_jbusinessdirectory_attributes a
left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type
left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id
left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=11744
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering93μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 1174453μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS
from brew_jbusinessdirectory_packages p
left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=11744
left join brew_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 desc525μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect * from brew_jbusinessdirectory_categories c
where c.id=241118μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`227μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM brew_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter6.43ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copyselect * from brew_jbusinessdirectory_categories c
where c.id=241120μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name293μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `brew_modules` AS `m`
LEFT JOIN `brew_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `brew_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)) 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`788μs2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copyselect * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name527μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'130μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'79μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'77μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'91μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'106μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'87μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'80μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'84μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'90μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'86μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'79μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'74μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'84μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'86μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'73μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'82μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'79μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'106μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT 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 `brew_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1151μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'criticalfiles'83μs64.84KB/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'86μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = ?111μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `brew_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?7.41ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy