×

Error

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM #__content as a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS um ON um.id = a.modified_by LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT JOIN #__viewlevels AS vl ON a.access = vl.id LEFT JOIN #__languages AS l ON a.language = l.lang_code LEFT JOIN #__contentitem_tag_map AS ct ON ct.content_item_id = a.id LEFT JOIN #__tags AS t ON t.id = ct.tag_id LEFT OUTER JOIN (select rsi.provider_id, rsi.order from #__roksprocket_items as rsi where module_id = 151) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,5) AND (a.state = 1 or a.state = 2) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 02:11:54') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 02:11:54') AND (a.state != -2)) AND a.catid IN (11)) GROUP BY id ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order LIMIT 10
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
SAN JOSÉ - CRC
MÉXICO D.F.
NEW YORK CITY
CARACAS
RIO de JANEIRO
MADRID

CÓDIGO 2018

  • RESULTADOS
  • PRÓXIMA FECHA

(Hora GMT -6)

Viernes 11 Noviembre, 2016 07:01
 
USA 1 : 2 MEX
Viernes 11 Noviembre, 2016 05:05
 
TRI 0 : 2 CRC
Viernes 11 Noviembre, 2016 02:35
 
HON 0 : 1 PAN

(Hora GMT -6)

Viernes 24 Marzo, 2017 17:00
 
TRI - PAN
Viernes 24 Marzo, 2017 19:50
 
MEX - CRC
Viernes 24 Marzo, 2017 20:50
 
USA - HON