Could not query: Column 'Category_LegacyID' in where clause is ambiguous
SELECT Category.*, `Group`.Category_Name AS Group_Name, ProductType.Category_Name AS ProductType_Name FROM Category INNER JOIN CategoryWebsite ON CategoryWebsite_WebsiteID = 4 AND CategoryWebsite_CategoryID = Category.Category_ID INNER JOIN Category AS `Group` ON `Group`.Category_ID = Category.Category_ParentCategoryID INNER JOIN Category AS ProductType ON ProductType.Category_ID = Group.Category_ParentCategoryID WHERE Category_LegacyID = '146' AND Category_LegacyTable = 'family_group'
Error
   

   Registered Company Number: 3832422 - VAT Number: GB740 7652 32
   AMEC Thermasol is a division of Marcom Electronic Components (UK) Ltd.
   Copyright © 2016 Marcom Electronic Components (UK) Limited. - All rights reserved.
   View sitemap.

   Address:   AMEC Thermasol, Marcom House, 1-2 Steam Mill Lane, Great Yarmouth, Norfolk, NR31 0HP, United Kingdom.

ISOQAR
Cert: 4823
ISO 9001