Unknown column 'product_badge_translation.title' in 'field list'
			SELECT SQL_CALC_FOUND_ROWS
				product.id,
				product.product_category_id,
				product_translation.title,
				product_translation.title_html,
				product_translation.lead,
				product.picture,
				CASE WHEN product_dimension_mtm_product_color.price_override THEN product_dimension_mtm_product_color.price_override WHEN product_dimension.price_override THEN product_dimension.price_override ELSE product_price.price END AS price,
				product_badge.picture as badge_picture,
				product_badge_translation.title as badge_title
			FROM
				product
				CROSS JOIN product_translation ON product_translation.product_id = product.id AND product_translation.language_id = 'en'
			LEFT JOIN
				product_dimension
				ON
				product_dimension.product_id = product.id
			LEFT JOIN
				product_dimension_mtm_product_color
				ON
				product_dimension_mtm_product_color.product_dimension_id = product_dimension.id
			LEFT JOIN
				product_mtm_product_badge
				ON
				product_mtm_product_badge.product_id = product.id
			LEFT JOIN
				product_badge
				ON
				product_mtm_product_badge.product_badge_id = product_badge.id
			LEFT JOIN
				product_price
				ON
				product_price.id = CASE WHEN product_dimension_mtm_product_color.code THEN product_dimension_mtm_product_color.code ELSE product_dimension.code END
			WHERE
				NOT product.hidden
			GROUP BY
				product.id
			ORDER BY
				product.is_featured DESC,
				product.ord ASC,
				product.id ASC
		 LIMIT 0,12