Архив
| « |
|
26 Июн 2014 | » | |||
| Пн | Вт | Ср | Чт | Пт | Сб | Вс |
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | ||||||
Чемпионат мира 2010
Table \'sportplane_sportnews.sn_joomleague_rounds\' doesn\'t exist SQL=SELECT m.match_date AS datum, \n m.matchpart1 AS home, \n m.matchpart2 AS away, \n m.*, \n r.matchcode, r.name as round, \n t1.middle_name AS home_name, \n t2.middle_name AS away_name, \n t1.middle_name AS home_mn, \n t2.middle_name AS away_mn, \n c1.logo_middle AS home_logo, \n c2.logo_middle AS away_logo, \n j.name AS project_name FROM sn_joomleague_matches AS m \n INNER JOIN sn_joomleague AS j ON m.project_id = j.id \n INNER JOIN sn_joomleague_rounds AS r ON m.round_id = r.id \n INNER JOIN sn_joomleague_teams AS t1 ON m.matchpart1 = t1.id \n INNER JOIN sn_joomleague_teams AS t2 ON m.matchpart2 = t2.id \n LEFT JOIN sn_joomleague_clubs AS c1 ON t1.club_id = c1.id \n LEFT JOIN sn_joomleague_clubs AS c2 ON t2.club_id = c2.id WHERE m.project_id IN (36) \n AND DATE_ADD(m.match_date, INTERVAL \'1\' DAY)>= \'2014-06-26\' \n AND DATE_ADD(m.match_date, INTERVAL \'1\' DAY)<= \'2014-06-26 23:59:59\' ORDER by m.match_result_type>10 DESC, m.match_date, datum
В расписании матчей нет
Table \'sportplane_sportnews.sn_joomleague_rounds\' doesn\'t exist SQL=SELECT m.match_date AS datum, \n m.matchpart1 AS home, \n m.matchpart2 AS away, \n m.*, \n r.matchcode, r.name as round, \n t1.middle_name AS home_name, \n t2.middle_name AS away_name, \n t1.middle_name AS home_mn, \n t2.middle_name AS away_mn, \n c1.logo_middle AS home_logo, \n c2.logo_middle AS away_logo, \n j.name AS project_name FROM sn_joomleague_matches AS m \n INNER JOIN sn_joomleague AS j ON m.project_id = j.id \n INNER JOIN sn_joomleague_rounds AS r ON m.round_id = r.id \n INNER JOIN sn_joomleague_teams AS t1 ON m.matchpart1 = t1.id \n INNER JOIN sn_joomleague_teams AS t2 ON m.matchpart2 = t2.id \n LEFT JOIN sn_joomleague_clubs AS c1 ON t1.club_id = c1.id \n LEFT JOIN sn_joomleague_clubs AS c2 ON t2.club_id = c2.id WHERE m.project_id IN (36) \n AND DATE_ADD(m.match_date, INTERVAL \'0\' DAY)>= \'2014-06-26\' \n AND DATE_ADD(m.match_date, INTERVAL \'0\' DAY)<= \'2014-06-26 23:59:59\' ORDER by m.match_result_type>10 DESC, m.match_date, datum
В расписании матчей нет
Table \'sportplane_sportnews.sn_joomleague_rounds\' doesn\'t exist SQL=SELECT m.match_date AS datum, \n m.matchpart1 AS home, \n m.matchpart2 AS away, \n m.*, \n r.matchcode, r.name as round, \n t1.middle_name AS home_name, \n t2.middle_name AS away_name, \n t1.middle_name AS home_mn, \n t2.middle_name AS away_mn, \n c1.logo_middle AS home_logo, \n c2.logo_middle AS away_logo, \n j.name AS project_name FROM sn_joomleague_matches AS m \n INNER JOIN sn_joomleague AS j ON m.project_id = j.id \n INNER JOIN sn_joomleague_rounds AS r ON m.round_id = r.id \n INNER JOIN sn_joomleague_teams AS t1 ON m.matchpart1 = t1.id \n INNER JOIN sn_joomleague_teams AS t2 ON m.matchpart2 = t2.id \n LEFT JOIN sn_joomleague_clubs AS c1 ON t1.club_id = c1.id \n LEFT JOIN sn_joomleague_clubs AS c2 ON t2.club_id = c2.id WHERE m.project_id IN (36) \n AND DATE_ADD(m.match_date, INTERVAL \'-1\' DAY)>= \'2014-06-26\' \n AND DATE_ADD(m.match_date, INTERVAL \'-1\' DAY)<= \'2014-06-26 23:59:59\' ORDER by m.match_result_type>10 DESC, m.match_date, datum
В расписании матчей нет
АКТУАЛЬНО
ДРУГИЕ МАТЕРИАЛЫ
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AND s.published = 1\n AND cc.published = 1\n ORDER BY a.created DESC\n limit 0,14\' at line 10 SQL=SELECT a.*, s.name AS sec_name, cc.name AS cat_name\n FROM sn_content AS a\n LEFT JOIN sn_content_frontpage AS f ON f.content_id = a.id\n INNER JOIN sn_categories AS cc ON cc.id = a.catid\n INNER JOIN sn_sections AS s ON s.id = a.sectionid\n WHERE ( a.state = 1 AND a.sectionid > 0 )\n AND ( a.publish_up = \'0000-00-00 00:00:00\' OR a.publish_up <= \'2014-06-26 19:17\' )\n AND ( a.publish_down = \'0000-00-00 00:00:00\' OR a.publish_down >= \'2014-06-26 19:17\' ) AND a.sectionid=2\n AND a.id !=\n AND s.published = 1\n AND cc.published = 1\n ORDER BY a.created DESC\n limit 0,14|
|
