PEAR-Error
MDB2 Error: syntax error: _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT
				p.product_id,
				p.no,
				p.textile_no,
				p.list_price,
				p.eur_list_price,
				pt.hu_name AS name
			  FROM
				macma.ZMS_Shop_Products AS p,
			  LEFT JOIN macma.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no	
			  WHERE
				p.in_action=1
				AND p.item_brand   IN ('Result', 'M-Collection', 'CrisMa', '7 Ceramics', 'Ferraghini', 'B&C', 'Fruit of the Loom', 'Stedman', 'Valento', 'Mark Twain', 'USB', 'SX', 'Keya', 'Superior SPA', 'RUSSELL', 'Gildan', 'Sols', 'Regatta', 'CoFee', 'Kariban', 'Pierre Cardin', 'Vanilla Season', 'Schwarzwolf', 'SPA') 
			  ORDER BY RAND() LIMIT 9]
[Native code: 1064]
[Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN macma.ZMS_Shop_Products_Texts AS pt ON pt.no=p.no	
			  WHERE
				p.' at line 10]