Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -43,7 +43,55 @@
43	43	|Сезонность
44	44
45	45
	46	+**Применяемость**
46	46
	48	+Делаем запрос через SQL:
	49	+
	50	+**SELECT**
	51	+
	52	+//br//.name **AS** 'Бренд'
	53	+
	54	+ ,//p//.code **AS** 'Артикул'
	55	+
	56	+ ,//am//.code **AS** 'Номер TecDoc легковой'
	57	+
	58	+ ,//am//.codeEx **AS** 'Номер TecDoc грузовой'
	59	+
	60	+ ,//am//.lnktargettypeID **AS** 'Linkage Target Type ID'
	61	+
	62	+**FROM** products //p//
	63	+
	64	+**LEFT** **JOIN** ausage //au//
	65	+
	66	+**ON** //p//.id = //au//.product_id
	67	+
	68	+**LEFT** **JOIN** amodification //am//
	69	+
	70	+**ON** //au//.modification_id = //am//.id
	71	+
	72	+**LEFT** **JOIN** product_group //pg//
	73	+
	74	+**ON** //p//.group_id = //pg//.id
	75	+
	76	+**LEFT** **JOIN** brands //br//
	77	+
	78	+**ON** //pg//.brand_id = //br//.id
	79	+
	80	+**WHERE** 1 = 1
	81	+
	82	+**~ AND** (//p//.status_id = 4 **OR** //p//.status_id = 5)
	83	+
	84	+**~ AND** //am//.lnktargettypeID **IS** **NOT** **null**
	85	+
	86	+**~ AND** //br//.id **IN** (1, 2, 3, 4, 5)
	87	+
	88	+**ORDER** **BY**
	89	+
	90	+//br//.name,
	91	+
	92	+//p//.code
	93	+
	94	+
47	47	1. **Разнообразная информация об артикуле (24 столбца)**
48	48
49	49	|**Поле РОССКО**|**Поле Карвиль (NPR)**