Calendar
user warning: Unknown column 'node_data_field_event_date.field_fixture_date_value' in 'where clause'
query: SELECT node.nid AS nid,
node_data_field_fixture_date.field_fixture_date_value AS node_data_field_fixture_date_field_fixture_date_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_league.field_league_nid AS node_data_field_league_field_league_nid,
node.title AS node_title,
node_node_data_field_team_club_node_data_field_start_time.field_start_time_value AS node_node_data_field_team_club_node_data_field_start_time_field_start_time_value,
node_node_data_field_team_club.nid AS node_node_data_field_team_club_nid,
node_node_data_field_team_club.type AS node_node_data_field_team_club_type,
node_node_data_field_team_club.vid AS node_node_data_field_team_club_vid,
node_node_data_field_team_club_node_data_field_start_time.field_end_time_value AS node_node_data_field_team_club_node_data_field_start_time_field_end_time_value,
node_data_field_event_date.field_event_date_value AS node_data_field_event_date_field_event_date_value,
node_data_field_event_date.field_event_date_value2 AS node_data_field_event_date_field_event_date_value2
FROM node node
LEFT JOIN content_type_fixture node_data_field_home_team ON node.vid = node_data_field_home_team.vid
LEFT JOIN node node_node_data_field_home_team ON node_data_field_home_team.field_home_team_nid = node_node_data_field_home_team.nid
LEFT JOIN content_type_team node_node_data_field_home_team_node_data_field_team_club ON node_node_data_field_home_team.vid = node_node_data_field_home_team_node_data_field_team_club.vid
LEFT JOIN node node_node_data_field_team_club ON node_node_data_field_home_team_node_data_field_team_club.field_team_club_nid = node_node_data_field_team_club.nid
LEFT JOIN content_type_event node_data_field_event_date ON node.vid = node_data_field_event_date.vid
LEFT JOIN content_type_fixture node_data_field_fixture_date ON node.vid = node_data_field_fixture_date.vid
LEFT JOIN content_field_league node_data_field_league ON node.vid = node_data_field_league.vid
LEFT JOIN content_type_club node_node_data_field_team_club_node_data_field_start_time ON node_node_data_field_team_club.vid = node_node_data_field_team_club_node_data_field_start_time.vid
WHERE (node.status <> 0)
AND ((DATE_FORMAT(node_data_field_event_date.field_event_date_value, '%Y-%m-%d') >= '2010-07-29') OR (DATE_FORMAT(node_data_field_event_date.field_fixture_date_value, '%Y-%m-%d') >= '2010-07-29'))
ORDER BY node_data_field_fixture_date_field_fixture_date_value ASC
in /var/www/badminton/drupal/sites/all/modules/views/includes/view.inc on line 769.
| Time | Items |
|---|---|
| All day |
|
| All times |
|
Recent comments
17 weeks 1 day ago
20 weeks 1 day ago
20 weeks 1 day ago
21 weeks 18 hours ago
23 weeks 1 day ago
24 weeks 1 day ago
24 weeks 6 days ago
25 weeks 1 day ago
26 weeks 1 day ago
26 weeks 5 days ago