| 0.0018 | SELECT cs.region, cs.currency, cs.currency_text, cs.pricing, cs.site_code, cs.default_language AS site_lang, cs.id AS site_id, cs.catalog_id
FROM catalog_sites cs
INNER JOIN catalog_site_countries css ON css.site_id = cs.id
WHERE css.country_code = 'US' |
| 0.0073 | SELECT sec.title AS section_title, c.id, c.created, c.title, LOWER(c.alias) AS alias, c.title_alias, c.sectionid, c.catid, c.state, c.publish_up, c.metakey, c.metadesc, c.introtext, c.fulltext, c.ordering, c.images, c.alt_img_txt, c.cat_weight, c.media_id, c.section_head, c.template, languages.code as lang, sec.alias AS section
FROM (`jos_sections` sec)
JOIN `jos_content` c ON sec.id = c.sectionid
JOIN `osc_languages` languages ON languages.languages_id = c.langid
WHERE sec.alias = 'athletes'
AND languages.code = 'en'
AND c.state >= 2
AND c.publish_up <= NOW()
AND (c.publish_down >= NOW() OR c.publish_down = '0000-00-00 00:00:00')
AND ( ! (c.introtext = '' AND c.fulltext = '') )
ORDER BY c.section_head desc, c.cat_weight desc, c.created desc |
