<b>Unknown</b>: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in <b>/home/shara/public_html/system/database/mysql.php</b> on line <b>6</b><b>Notice</b>: Error: Table 'shara_tecdoc.SUPPLIERS' doesn't exist<br />Error No: 1146<br />
			SELECT DISTINCT
			 IF (ART_LOOKUP.ARL_KIND IN (3, 4), BRANDS.BRA_BRAND, SUPPLIERS.SUP_BRAND) AS BRAND,
			 ART_LOOKUP.ARL_SEARCH_NUMBER AS NUMBER,
			 ART_LOOKUP.ARL_KIND,
			 ART_LOOKUP.ARL_ART_ID,
			 DES_TEXTS.TEX_TEXT AS ART_COMPLETE_DES_TEXT
			FROM
						ART_LOOKUP
			  LEFT JOIN BRANDS ON BRANDS.BRA_ID = ART_LOOKUP.ARL_BRA_ID
			 INNER JOIN ARTICLES ON ARTICLES.ART_ID = ART_LOOKUP.ARL_ART_ID
			 INNER JOIN SUPPLIERS ON SUPPLIERS.SUP_ID = ARTICLES.ART_SUP_ID
			 INNER JOIN DESIGNATIONS ON DESIGNATIONS.DES_ID = ARTICLES.ART_COMPLETE_DES_ID
			 INNER JOIN DES_TEXTS ON DES_TEXTS.TEX_ID = DESIGNATIONS.DES_TEX_ID
			WHERE
			 ART_LOOKUP.ARL_SEARCH_NUMBER IN ('10А0665С') AND
			 ART_LOOKUP.ARL_KIND IN (1, 2, 3, 4) AND
			 DESIGNATIONS.DES_LNG_ID = 16
			GROUP BY
			 BRAND,
			 NUMBER in <b>/home/shara/public_html/system/database/mysql.php</b> on line <b>49</b>