Sql error of
/videogamedatabase/results.php. In /home/retrocol/public_html/videogamedatabase/lib/functions.php on line: 91
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 '2 GROUP BY items.item_id' at line 1
SQL:SELECT items.item_id, items.item_title, items.item_recommendation, items.item_rarity, platforms.platform, platforms.platform_id, platforms.ebay, release_dates.release_date_year, c_publisher.company_name as publisher_company, c_developer.company_name as developer_company, items.item_main_variant_id, collectors_regions.collectors_region_id, regions.region_id, akas.aka_title, item_votes_avg.item_vote_avg from items INNER JOIN item_platform_rel ON (item_platform_rel.item_id = items.item_id) INNER JOIN platforms ON (platforms.platform_id = item_platform_rel.platform_id) LEFT JOIN akas ON (akas.item_id = items.item_id) LEFT JOIN release_dates ON (release_dates.item_id = items.item_id) INNER JOIN item_company_rel icrpublishers ON (icrpublishers.item_id = items.item_id) INNER JOIN item_company_rel icrdevelopers ON (icrdevelopers.item_id = items.item_id) INNER JOIN companies c_publisher ON (c_publisher.company_id = icrpublishers.company_id AND icrpublishers.item_company_rel_type='Publisher') INNER JOIN companies c_developer ON (c_developer.company_id = icrdevelopers.company_id AND icrdevelopers.item_company_rel_type='Developer') LEFT JOIN item_subgenre_rel ON (item_subgenre_rel.item_id = items.item_id) LEFT JOIN subgenres ON (subgenres.subgenre_id = item_subgenre_rel.subgenre_id) LEFT JOIN genres ON (genres.genre_id = subgenres.genre_id) LEFT JOIN collectors_regions ON (collectors_regions.collectors_region_id = items.item_collectors_region_id) LEFT JOIN item_regions_rel ON (item_regions_rel.item_id = items.item_id) LEFT JOIN item_votes_avg ON (item_votes_avg.item_id = items.item_id) LEFT JOIN regions ON (regions.region_id = item_regions_rel.region_id) INNER JOIN collections ON (items.item_id = collections.item_id) WHERE items.item_distribution_channel != 'Unreleased' AND collections.user_id = '2184' AND items.item_rarity %3D 2 GROUP BY items.item_id