I am getting a MySQL syntax error and I am unsure why. Any help would be appreciated. The error says unexpected single quoted text.

Here is a the code for the error.

SET @c = CONCAT('INSERT INTO ', @tableName, (

SELECT subq.modelYearID, subq.vehicleType, subq.pollutant, ROUND(subq.year1, 3), ROUND(subq.year2, 3), ROUND(subq.year3, 3), ROUND(subq.year4, 3), ROUND(subq.year5, 3), ROUND(subq.year6, 3), ROUND(subq.year7, 3), ROUND(subq.year8, 3), ROUND(subq.year9, 3), ROUND(subq.year10, 3), ROUND(subq.year11, 3), ROUND(subq.year12, 3), ROUND(subq.year13, 3), ROUND(subq.year14, 3), ROUND(subq.year15, 3), ROUND(subq.year16, 3), ROUND(subq.year17, 3), ROUND(subq.year18, 3), ROUND(subq.year19, 3), ROUND(subq.year20, 3), ROUND(subq.year21, 3), ROUND(subq.year22, 3), ROUND(subq.year23, 3), ROUND(subq.year24, 3), ROUND(subq.year25, 3), ROUND(subq.year26, 3), ROUND(subq.year27, 3), ROUND(subq.year28, 3), ROUND(subq.year29, 3), ROUND(subq.year30, 3), ROUND(subq.year31, 3) FROM( SELECT a.modelYearID, a.fuelTypeID, a.sourceTypeID, a.pollutantID, concat_ws(", ", sourceTypeName, fuelTypeDesc) vehicleType, CASE WHEN pollutantName = "Carbon Monoxide (CO)" THEN "CO" WHEN pollutantName = "Oxides of Nitrogen (NOx)" THEN "NOx" WHEN pollutantName = "Primary Exhaust PM10 - Total" THEN "PM10" ELSE "PM2.5" END AS pollutant, a.year1, a.year2, a.year3, a.year4, a.year5, a.year6, a.year7, a.year8, a.year9, a.year10, a.year11, a.year12, a.year13, a.year14, a.year15, a.year16, a.year17, a.year18, a.year19, a.year20, a.year21, a.year22, a.year23, a.year24, a.year25, a.year26, a.year27, a.year28, a.year29, a.year30, a.year31 FROM(SELECT modelYearID, processType, fuelTypeID, sourceTypeID, pollutantID,

SUM(IF(yearID = @startYear, emissionRate, 0)) AS year1, SUM(IF(yearID = @startYear + 1, emissionRate, 0)) AS year2, SUM(IF(yearID = @startYear + 2, emissionRate, 0)) AS year3, SUM(IF(yearID = @startYear + 3, emissionRate, 0)) AS year4, SUM(IF(yearID = @startYear + 4, emissionRate, 0)) AS year5, SUM(IF(yearID = @startYear + 5, emissionRate, 0)) AS year6, SUM(IF(yearID = @startYear + 6, emissionRate, 0)) AS year7, SUM(IF(yearID = @startYear + 7, emissionRate, 0)) AS year8, SUM(IF(yearID = @startYear + 8, emissionRate, 0)) AS year9, SUM(IF(yearID = @startYear + 9, emissionRate, 0)) AS year10, SUM(IF(yearID = @startYear + 10, emissionRate, 0)) AS year11, SUM(IF(yearID = @startYear + 11, emissionRate, 0)) AS year12, SUM(IF(yearID = @startYear + 12, emissionRate, 0)) AS year13, SUM(IF(yearID = @startYear + 13, emissionRate, 0)) AS year14, SUM(IF(yearID = @startYear + 14, emissionRate, 0)) AS year15, SUM(IF(yearID = @startYear + 15, emissionRate, 0)) AS year16, SUM(IF(yearID = @startYear + 16, emissionRate, 0)) AS year17, SUM(IF(yearID = @startYear + 17, emissionRate, 0)) AS year18, SUM(IF(yearID = @startYear + 18, emissionRate, 0)) AS year19, SUM(IF(yearID = @startYear + 19, emissionRate, 0)) AS year20, SUM(IF(yearID = @startYear + 20, emissionRate, 0)) AS year21, SUM(IF(yearID = @startYear + 21, emissionRate, 0)) AS year22, SUM(IF(yearID = @startYear + 22, emissionRate, 0)) AS year23, SUM(IF(yearID = @startYear + 23, emissionRate, 0)) AS year24, SUM(IF(yearID = @startYear + 24, emissionRate, 0)) AS year25, SUM(IF(yearID = @startYear + 25, emissionRate, 0)) AS year26, SUM(IF(yearID = @startYear + 26, emissionRate, 0)) AS year27, SUM(IF(yearID = @startYear + 27, emissionRate, 0)) AS year28, SUM(IF(yearID = @startYear + 28, emissionRate, 0)) AS year29, SUM(IF(yearID = @startYear + 29, emissionRate, 0)) AS year30, SUM(IF(yearID = @startYear + 30, emissionRate, 0)) AS year31 FROM emissionratesbyprocesstypenationalscale_totalexhaust WHERE modelYearID = @startYear GROUP BY fuelTypeID, sourceTypeID, pollutantID, processType) a, ',@MOVESdefaultdb,'.pollutant c, ',@MOVESdefaultdb,'.sourceusetype d, ',@MOVESdefaultdb,'.fueltype e

WHERE a.pollutantID = c.pollutantID AND a.sourceTypeID = d.sourceTypeID AND a.fuelTypeID = e.fuelTypeID AND processType = "Exhaust"

AND pollutantName IN ("Carbon Monoxide (CO)", "Oxides of Nitrogen (NOx)", "Primary Exhaust PM10 - Total", "Primary Exhaust PM2.5 - Total")

= SUM(IF(yearID @startYear + 21, emissionRate, )) AS year22, SUM(IF(yearID @startYear + 22, emissionRate, )) AS year23, SUM(IF(yearID @startYear + 23, emissionRate, )) AS year 24, SUM(IF(yearID @startYear + 24, emissionRate, )) AS year25, SUM(IF(yearID @startYear + 25, emissionRate, o)) AS year26, SUM(IF(yearID @startYear + 26, emissionRate, )) AS year27, SUM(IF(yearID @startYear + 27, emissionRate, )) AS year28, SUM(IF (yearID @startYear + 28, emissionRate, )) AS year29, SUM(IF (yearID @startYear + 29, emissionRate, )) AS year30, SUM(IF(yearID = @startYear + 30, emissionRate, )) AS year31 FROM emissionratesbyprocesstypenationalscale_totalexhaust = 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 X 139 140 141 142 143 144 145 146 147 148 149 150 151 152 WHERE modelYearID = @startYear GROUP BY fuelTypeID, sourceTypeID, pollutantID, processType) a, WARMQvesdefault.dkwww.pollutant , @MOVESdefaul Syntax error: unexpected ', @MOVESdefaultdb,' (single quoted text) @MOVESdefaultdb,'.fueltype e WHERE a.pollutantID c. pollutantID AND a.sourceTypeID d.sourceTypeID AND a. fuelTypeID e. fuelTypeID AND processType = "Exhaust" AND pollutantName IN ("Carbon Monoxide (CO)", "Oxides of Nitrogen (NOx)", "Primary Exhaust PM10 Total", "Primary Exhaust PM2.5 - Total") GROUP BY vehicleType, pollutant UNION SELECT a.model YearID, a. fuelTypeID, a. sourceTypeID, a.pollutantID