Summary

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

Details

Page properties

Content

...	...	@@ -70,35 +70,35 @@
70	70
71	71	**LEFT** **JOIN** product_group //pg//
72	72
73		- **ON** //p//.group_id = //pg//.id
	73	+ **ON** //p//.group_id = //pg//.id
74	74
75	75	**LEFT** **JOIN** brands //b//
76	76
77		- **ON** //pg//.brand_id = //b//.id
	77	+ **ON** //pg//.brand_id = //b//.id
78	78
79	79	**LEFT** **JOIN** product_oem //po//
80	80
81		- **ON** //p//.id = //po//.product_id
	81	+ **ON** //p//.id = //po//.product_id
82	82
83	83	**LEFT** **JOIN** oem_codes //oc//
84	84
85		- **ON** //po//.oem_id = //oc//.id
	85	+ **ON** //po//.oem_id = //oc//.id
86	86
87	87	**LEFT** **JOIN** oem_mark //om//
88	88
89		- **ON** //oc//.oemmarkId = //om//.id
	89	+ **ON** //oc//.oemmarkId = //om//.id
90	90
91	91	**WHERE** 1 = 1
92	92
93		- **AND** oc.code **IS** **NOT** **NULL**
	93	+ **AND** oc.code **IS** **NOT** **NULL**
94	94
95		- **AND** om.name **IS** **NOT** **NULL**
	95	+ **AND** om.name **IS** **NOT** **NULL**
96	96
97		- **AND** om.tecdocId **IS** **NOT** **NULL**
	97	+ **AND** om.tecdocId **IS** **NOT** **NULL**
98	98
99		- **AND** p.status_id **in** (4, 5)
	99	+ **AND** p.status_id **in** (4, 5)
100	100
101		- **AND** b.id **IN** (1, 2, 3, 4, 5)
	101	+ **AND** b.id **IN** (1, 2, 3, 4, 5)
102	102
103	103	~-~-AND oc.code NOT LIKE '%[а-я]%'
104	104
...	...	@@ -108,7 +108,7 @@
108	108
109	109	**SELECT**
110	110
111		- //b//.name **AS** 'Бренд'
	111	+ //b//.name **AS** 'Бренд'
112	112
113	113	,//p//.code **AS** Артикул
114	114
...	...	@@ -122,35 +122,35 @@
122	122
123	123	**LEFT** **JOIN** product_group //pg//
124	124
125		- **ON** //p//.group_id = //pg//.id
	125	+ **ON** //p//.group_id = //pg//.id
126	126
127	127	**LEFT** **JOIN** brands //b//
128	128
129		- **ON** //pg//.brand_id = //b//.id
	129	+ **ON** //pg//.brand_id = //b//.id
130	130
131	131	**LEFT** **JOIN** product_codes //pc//
132	132
133		- **ON** //p//.id = //pc//.product_id
	133	+ **ON** //p//.id = //pc//.product_id
134	134
135	135	**LEFT** **JOIN** codes //c//
136	136
137		- **ON** //pc//.code_id = //c//.id
	137	+ **ON** //pc//.code_id = //c//.id
138	138
139	139	**LEFT** **JOIN** oem_mark //om//
140	140
141		- **ON** //pc//.oem_mark_id = //om//.id
	141	+ **ON** //pc//.oem_mark_id = //om//.id
142	142
143	143	**WHERE** 1 = 1
144	144
145		- **AND** //c//.code **IS** **NOT** **NULL**
	145	+ **AND** //c//.code **IS** **NOT** **NULL**
146	146
147		- **AND** //om//.name **IS** **NOT** **NULL**
	147	+ **AND** //om//.name **IS** **NOT** **NULL**
148	148
149		- **AND** //om//.tecdocId **IS** **NOT** **NULL**
	149	+ **AND** //om//.tecdocId **IS** **NOT** **NULL**
150	150
151		- **AND** //p//.status_id **IN** (4, 5)
	151	+ **AND** //p//.status_id **IN** (4, 5)
152	152
153		- **AND** //b//.id **IN** (1, 2, 3, 4, 5)
	153	+ **AND** //b//.id **IN** (1, 2, 3, 4, 5)
154	154
155	155	~-~-AND c.code NOT LIKE '%[а-я]%'
156	156
...	...	@@ -172,7 +172,7 @@
172	172
173	173	**SELECT**
174	174
175		- //br//.name **AS** 'Бренд'
	175	+ //br//.name **AS** 'Бренд'
176	176
177	177	,//p//.code **AS** 'Артикул'
178	178
...	...	@@ -186,37 +186,37 @@
186	186
187	187	**LEFT** **JOIN** ausage //au//
188	188
189		- **ON** //p//.id = //au//.product_id
	189	+ **ON** //p//.id = //au//.product_id
190	190
191	191	**LEFT** **JOIN** amodification //am//
192	192
193		- **ON** //au//.modification_id = //am//.id
	193	+ **ON** //au//.modification_id = //am//.id
194	194
195	195	**LEFT** **JOIN** product_group //pg//
196	196
197		- **ON** //p//.group_id = //pg//.id
	197	+ **ON** //p//.group_id = //pg//.id
198	198
199	199	**LEFT** **JOIN** brands //br//
200	200
201		- **ON** //pg//.brand_id = //br//.id
	201	+ **ON** //pg//.brand_id = //br//.id
202	202
203	203	**WHERE** 1 = 1
204	204
205		- **AND** (//p//.status_id = 4 **OR** //p//.status_id = 5)
	205	+ **AND** (//p//.status_id = 4 **OR** //p//.status_id = 5)
206	206
207	207	~-~-AND p.code = 'AG 15024'
208	208
209		- **AND** //am//.lnktargettypeID **IS** **NOT** **null**
	209	+ **AND** //am//.lnktargettypeID **IS** **NOT** **null**
210	210
211		- **AND** //br//.id **IN** (1, 2, 3, 4, 5)
	211	+ **AND** //br//.id **IN** (1, 2, 3, 4, 5)
212	212
213		- **AND** //br//.id = 2
	213	+ **AND** //br//.id = 2
214	214
215	215	**ORDER** **BY**
216	216
217		- //br//.name,
	217	+ //br//.name,
218	218
219		- //p//.code
	219	+ //p//.code
220	220
221	221
222	222	В полученной выгрузке добавляем столбец с условием:
...	...	@@ -237,7 +237,6 @@
237	237	|Двигатели (Engines)|14
238	238
239	239
240		-
241	241	= **Загрузка фотографий в TecDoc** =
242	242
243	243