SQL failed: Unknown column 'prodShortDesc1.ppvValue' in 'where clause'|SELECT DISTINCT MATCH(prodName) AGAINST('+\' +t.search +\'') as relevance ,p.* FROM products p LEFT JOIN productBrand ON pbId = prodBrand INNER JOIN productGroups ON pgId = prodGroup AND pgShow = 1 AND prodShow = 1 LEFT JOIN prodDesignation ON pdProdId = prodId LEFT JOIN carModels ON cmId = pdCarModel WHERE (( prodDesc LIKE '%\'%' AND prodDesc LIKE '%t.search%' AND prodDesc LIKE '%\'%' ) OR ( prodCode LIKE '%\'%' AND prodCode LIKE '%t.search%' AND prodCode LIKE '%\'%' ) OR ( pbName LIKE '%\'%' AND pbName LIKE '%t.search%' AND pbName LIKE '%\'%' ) OR ( prodShortDesc1.ppvValue LIKE '%\'%' AND prodShortDesc1.ppvValue LIKE '%t.search%' AND prodShortDesc1.ppvValue LIKE '%\'%' ) OR ( prodShortDesc2.ppvValue LIKE '%\'%' AND prodShortDesc2.ppvValue LIKE '%t.search%' AND prodShortDesc2.ppvValue LIKE '%\'%' ) OR ( prodDesc1.ppvValue LIKE '%\'%' AND prodDesc1.ppvValue LIKE '%t.search%' AND prodDesc1.ppvValue LIKE '%\'%' ) OR ( prodDesc2.ppvValue LIKE '%\'%' AND prodDesc2.ppvValue LIKE '%t.search%' AND prodDesc2.ppvValue LIKE '%\'%' )) ORDER BY relevance DESC, prodName ASC LIMIT 0, 18