En MODELS.sql

/* Display of model list for a specified car brand (MFA_ID) */

/* MOD_ID - Model number */

/* MOD_CDS_TEXT - Model name */

/* MOD_PCON_START - YYYYMM: model release Year/month */

/* MOD_PCON_END - YYYYMM: model production termination Year/month (NULL - unlimited) */

SET @MFA_ID = 502; /* ALFA ROMEO */
SET @LNG_ID = 16; /* 1 - German; 16 - Russian */

SELECT	MOD_ID,	TEX_TEXT AS MOD_CDS_TEXT,	MOD_PCON_START,	MOD_PCON_END
FROM	           MODELS
INNER JOIN COUNTRY_DESIGNATIONS ON CDS_ID = MOD_CDS_ID
INNER JOIN DES_TEXTS ON TEX_ID = CDS_TEX_ID
WHERE	MOD_MFA_ID = @MFA_ID AND	CDS_LNG_ID = @LNG_ID
ORDER BY	MOD_CDS_TEXT
LIMIT	100;

• Back to index page: Tecdoc_queries_and_structure_manual_-_version_2

• Prices and packages for Irbis software based on tecdoc from Mstarproject company: http://www.mstarproject.com/en/?action=tecdoc_mysql_site