error in sql query
			SELECT
				products.pid,
				products.allow_sales_orders,
				products.internal_status,
				products.code,
				products.gid,
				product_text.title,
				product_text.variation_title,
				product_text.keywords,
				product_text.overview,
				product_text.description,
				product_text.video_demonstration,
				products.pack_size_group,
				products.pack_size_value,
				products.manufacturer_id,
				products.weight,
				products.free_shipping,
				product_url_keys.url_key,
				product_groups.type AS group_type,
				product_groups.name AS group_title,
				product_groups.visually_different AS group_visually_different,
				products.colour_hex,
				products.selling_unit,
				products.available_stock,
				products.expected_date,
				products.stock_display_ceiling,
				products.stock_mode,
				products.author,
				products.designer,
				GROUP_CONCAT(DISTINCT(product_contributors.name) ORDER BY product_contributors.name ASC) AS contributors,
				manufacturers.manufacturer_name AS manufacturer,
				products.manufacturer_stock_code
			FROM
				products
				INNER JOIN products_categories
					ON products.pid = products_categories.pid
				INNER JOIN product_text
					ON product_text.product_id = products.pid AND product_text.language_id=1
				LEFT JOIN product_contributors
					ON products.pid = product_contributors.pid
				LEFT JOIN product_url_keys
					ON products.pid = product_url_keys.pid AND product_url_keys.catalogue_id = '1' AND product_url_keys.active='1'
				LEFT JOIN product_groups
					ON products.gid = product_groups.id
				LEFT JOIN manufacturers
					ON manufacturers.manufacturer_id = products.manufacturer_id
			WHERE
				products.pid=claydough-party-girl
				AND product_text.title IS NOT NULL
		
.mysql error : Unknown column 'claydough' in 'where clause'