Changes for page Выгрузка в TecDoc
Last modified by Александр Молчин on 2025/05/30 12:36
From version 17.2
edited by Александр Молчин
on 2025/05/29 07:24
on 2025/05/29 07:24
To version 17.3
edited by Александр Молчин
on 2025/05/30 06:25
on 2025/05/30 06:25
Change comment: There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -99,15 +99,15 @@ 99 99 100 100 **WHERE** 1 = 1 101 101 102 - 102 +**AND** p.status_id **IN** (4,5) 103 103 104 - 104 +**AND** b.name **IS NOT** null 105 105 106 - 106 +**AND** c.code **IS NOT** null 107 107 108 - 108 +**AND** om.name **IS NOT** null 109 109 110 - 110 +**AND** b.id **IN** (1, 2, 3, 4, 5) 111 111 112 112 ~-~-**AND** p.code = 'ALED061' 113 113 ... ... @@ -157,23 +157,23 @@ 157 157 158 158 **LEFT JOIN** oem_codes oc 159 159 160 - 160 +**ON **po.oem_id = oc.id 161 161 162 162 **LEFT JOIN** oem_mark om 163 163 164 - 164 +**ON **oc.oemmarkId = om.id 165 165 166 166 **WHERE** 1 = 1 167 167 168 - 168 +**AND** p.status_id **IN** (4,5) 169 169 170 - 170 +**AND** oc.code **IS NOT** NULL 171 171 172 172 **~ AND **om.name **IS NOT** NULL 173 173 174 - 174 +**AND** p.code **IS NOT** NULL 175 175 176 - 176 +**AND** b.id **IN** (1, 2, 3, 4, 5) 177 177 178 178 **ORDER BY** 179 179 ... ... @@ -262,7 +262,6 @@ 262 262 |Двигатели (Engines)|14 263 263 264 264 265 - 266 266 = **Загрузка фотографий в TecDoc** = 267 267 268 268