Error message
User error: Wrong SQL:
SELECT
competition.competition_id,
competition.start_date,
competition.name,
competition.city,
class_and_segment.class_and_segment_id,
class_and_segment.class_sex,
class_basename.name AS class_basename,
skater.skater_id,
skater.first_name,
skater.middle_name,
skater.last_name,
race.race_id,
race.film_reference,
race_details_element_score.actual_executed_element,
race_details_element_score.element_scores
FROM
competition,
class_and_segment,
class_basename,
skaters_club_affiliation,
race_details_element_score,
elements,
skater,
club,
race
WHERE
competition.competition_id = race.competition_id AND
class_and_segment.competition_id = race.competition_id AND
class_and_segment.class_and_segment_id = race.class_and_segment_id AND
class_and_segment.class_basename_id = class_basename.class_basename_id AND
race_details_element_score.competition_id = competition.competition_id AND
race_details_element_score.race_id = race.race_id AND
race_details_element_score.element_id = elements.element_id AND
elements.element_class = 4 AND
skater.skater_id = race.skater_id AND
skaters_club_affiliation.skater_id = skater.skater_id AND
skaters_club_affiliation.club_id = club.club_id AND
skaters_club_affiliation.start_date <= competition.start_date AND
skaters_club_affiliation.end_date >= competition.start_date AND
skater.skater_id = 9010 AND class_and_segment.class_sex != 'P'
ORDER BY
race_details_element_score.element_scores DESC, competition.start_date DESC LIMIT 3Error: Table 'rinkresults.club' doesn't exist in find_query_results() (line 481 of /usr/share/rinkresults/rrtools/php/query_tools.php).