I've got a pretty complex MySQL query running on a live site. And I need to add an additional search field -- but I keep coming with an unkown column in field list error.

Here's the existing query:
Code:
SELECT f.fieldID, f.fieldNew, f.fieldFeatured, f.fieldSale, f.fieldSaleAmount, f.fieldTitle, f.fieldDrillGrade, TRUNCATE(ROUND(AVG(i.itemGrade) * 2) / 2,1) AS fieldMusicGrade, g.genreName, (f.fieldSets1 + f.fieldSets2 + f.fieldSets3 + f.fieldSets4 + f.fieldSets5) AS fieldTotalSets, SUM(i.itemTime) AS fieldTotalTime, (IF(f.fieldMusicOnly != '', f.fieldMusicOnly, SUM(i.itemPrice)) + IF(f.fieldDrillOnly != '', f.fieldDrillOnly, o.optionPrice)) AS fieldTotalPrice
FROM field AS f
INNER JOIN items AS i ON i.itemID IN (f.fieldMusic1, f.fieldMusic2, f.fieldMusic3, f.fieldMusic4, f.fieldMusic5)
LEFT OUTER JOIN options AS o ON o.optionPerDrillGrade = f.fieldDrillGrade
LEFT OUTER JOIN genres AS g ON g.genreID = f.fieldGenre
WHERE f.fieldEnabled = 'Yes' AND (o.optionID = 662 OR o.optionID = 663 OR o.optionID = 664 OR o.optionID = 665) AND (f.fieldTitle LIKE '%test%' OR f.fieldSynopsis LIKE '%test%' OR f.fieldNotes LIKE '%test%' OR f.fieldKeywords LIKE '%test%')
AND NOT (COALESCE(fieldMusicTitle1,'') > '' OR COALESCE(fieldMusicTitle2,'') > '' OR COALESCE(fieldMusicTitle3,'') > '' OR COALESCE(fieldMusicTitle4,'') > '' OR COALESCE(fieldMusicTitle5,'') > '')
GROUP BY f.fieldID, f.fieldNew, f.fieldFeatured, f.fieldSale, f.fieldTitle, f.fieldDrillGrade, g.genreName
UNION ALL
SELECT f.fieldID, f.fieldNew, f.fieldFeatured, f.fieldSale, f.fieldSaleAmount, f.fieldTitle, f.fieldDrillGrade, fieldMusicGrade AS fieldMusicGradeAvg, g.genreName, (f.fieldSets1 + f.fieldSets2 + f.fieldSets3 + f.fieldSets4 + f.fieldSets5) AS fieldTotalSets, (f.fieldTime1 + f.fieldTime2 + f.fieldTime3 + f.fieldTime4 + f.fieldTime5) AS fieldTotalTime, (f.fieldMusicOnly + IF(f.fieldDrillOnly != '', f.fieldDrillOnly, o.optionPrice)) AS fieldTotalPrice
FROM field AS f
LEFT OUTER JOIN options AS o ON o.optionPerDrillGrade = f.fieldDrillGrade
LEFT OUTER JOIN genres AS g ON g.genreID = f.fieldGenre
WHERE f.fieldEnabled = 'Yes' AND (o.optionID = 662 OR o.optionID = 663 OR o.optionID = 664 OR o.optionID = 665) AND (f.fieldTitle LIKE '%test%' OR f.fieldSynopsis LIKE '%test%' OR f.fieldNotes LIKE '%test%' OR f.fieldKeywords LIKE '%test%')
AND (COALESCE(fieldMusicTitle1,'') > '' OR COALESCE(fieldMusicTitle2,'') > '' OR COALESCE(fieldMusicTitle3,'') > '' OR COALESCE(fieldMusicTitle4,'') > '' OR COALESCE(fieldMusicTitle5,'') > '')
ORDER BY fieldTitle
The new field I need to also search now is called i.itemComposer from the items table. When I add:
Code:
 OR i.itemComposer LIKE '%$searchText%'
To the WHERE clause -- I get an unknown column error.

How do I need to go about adding this? Thank you for any help you can provide.