ERROR SQL: Unknown column 'prices.articles_id' in 'on clause'
IN: 
				SELECT
					prices.id,
					UPPER( prices.artikul ) AS artikul,
					prices.count AS count,
					prices.brand_id,
					prices.price_rozn as price,
					prices.price_opt,
					prices.price_rozn,
					prices.price AS price_in,
					IF( prices.name != "", prices.name, ( SELECT name_ua FROM articles WHERE articles.main_brand_id = prices.brand_id AND articles.article_search = prices.artikul ) ) AS name,
					prices.supplierid as supplier,
					suppliers.region AS region,
					DATE_FORMAT( suppliers.up_date, "%d.%m.%Y" ) AS up_date,
					"USD" as currency,
					suppliers.add_day_time,
					suppliers.add_day,	
					suppliers.`return` AS `return`,
					UPPER( brands.brand ) as brand,
					SUBSTR( brands.description_brand, 1, 1 ) AS mainbrand_descr,
					brands.oe,
					0 AS analog,
					prices.apro AS apro,
					prices.podkapot AS podkapot,
					prices.deliver,
					IF( discount.value, discount.value, 0 ) AS discount_value,
					IF( discount.type, discount.type, "" ) AS discount_type,
					IF( discount.method, discount.method, "" ) AS discount_method
				FROM
					prices
				LEFT JOIN
					discount_article ON discount_article.article_id = prices.articles_id
				LEFT JOIN
					discount ON (
						discount.id = discount_article.discount_id
						AND ( 
							( discount.date_from < CURRENT_DATE() AND discount.date_to > CURRENT_DATE() )
							OR (
								( discount.date_from IS NULL AND discount.date_to IS NULL )
								OR ( discount.date_from IS NULL AND discount.date_to > CURRENT_DATE() )
								OR ( discount.date_from < CURRENT_DATE() AND discount.date_to IS NULL )
							)
						)
					)
				INNER JOIN
					suppliers ON prices.supplierid = suppliers.id
				INNER JOIN
					brands ON prices.brand_id = brands.id
				WHERE
					prices.id IN (768327681,808943653)
				ORDER BY 
					suppliers.id, prices.brand, prices.artikul