1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
|
SELECT
`new_view_2`.`entity_id` AS `entity_id`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajapp_inverse' THEN `new_view_2`.`value_boolean`
END) AS `ajapp_inverse`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_bordure' THEN `new_view_2`.`value_string`
END) AS `ajsus_bordure`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_btr' THEN `new_view_2`.`metric_data`
END) AS `ajsus_btr`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_diab end as' THEN `new_view_2`.`metric_data`
END) AS `ajsus_diabas`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_diahaut' THEN `new_view_2`.`metric_data`
END) AS `ajsus_diahaut`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_forme' THEN `new_view_2`.`value_string`
END) AS `ajsus_forme`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_hauteur' THEN `new_view_2`.`metric_data`
END) AS `ajsus_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_hauteur_db' THEN `new_view_2`.`metric_data`
END) AS `ajsus_hauteur_db`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_pente' THEN `new_view_2`.`metric_data`
END) AS `ajsus_pente`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_ttr' THEN `new_view_2`.`metric_data`
END) AS `ajsus_ttr`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsus_type_db' THEN `new_view_2`.`option_code`
END) AS `ajsus_type_db`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_commentaire' THEN `new_view_2`.`value_text`
END) AS `ajsusapp_commentaire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_carc_couleur' THEN `new_view_2`.`value_string`
END) AS `ajsusapp_carc_couleur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_couleur_cc' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_couleur_cc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_epaisseur_cc' THEN `new_view_2`.`metric_data`
END) AS `ajsusapp_epaisseur_cc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_finition_cc' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_finition_cc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_mode_thermoformage' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_mode_thermoformage`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_motif_licence' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_motif_licence`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_motif_place' THEN `new_view_2`.`value_boolean`
END) AS `ajsusapp_motif_place`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_poids' THEN `new_view_2`.`metric_data`
END) AS `ajsusapp_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_support_cc' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_support_cc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_type_joint_cc' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_type_joint_cc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ajsusapp_type_montage' THEN `new_view_2`.`option_code`
END) AS `ajsusapp_type_montage`,
(CASE `new_view_2`.`attribut_code`
WHEN 'app_largeur' THEN `new_view_2`.`metric_data`
END) AS `app_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'app_profondeur' THEN `new_view_2`.`metric_data`
END) AS `app_profondeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'app_type_elec' THEN `new_view_2`.`option_code`
END) AS `app_type_elec`,
(CASE `new_view_2`.`attribut_code`
WHEN 'avanc_cq' THEN `new_view_2`.`value_boolean`
END) AS `avanc_cq`,
(CASE `new_view_2`.`attribut_code`
WHEN 'avanc_sel' THEN `new_view_2`.`value_boolean`
END) AS `avanc_sel`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_coloris' THEN `new_view_2`.`value_string`
END) AS `com_coloris`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_commentaire' THEN `new_view_2`.`value_text`
END) AS `com_commentaire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_couleur_commerciale' THEN `new_view_2`.`value_string`
END) AS `com_couleur_commerciale`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_couleur' THEN `new_view_2`.`value_string`
END) AS `com_couleur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_couleur_erp' THEN `new_view_2`.`option_code`
END) AS `com_couleur_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_date_de_livraison' THEN `new_view_2`.`value_date`
END) AS `com_date_de_livraison`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_demande_origine' THEN `new_view_2`.`option_code`
END) AS `com_demande_origine`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_destination' THEN `new_view_2`.`value_string`
END) AS `com_destination`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_fichier_info_supp' THEN `new_view_2`.`file_path`
END) AS `com_fichier_info_supp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_hauteur' THEN `new_view_2`.`metric_data`
END) AS `com_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_largeur' THEN `new_view_2`.`metric_data`
END) AS `com_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_libelle' THEN `new_view_2`.`value_string`
END) AS `com_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_longueur' THEN `new_view_2`.`metric_data`
END) AS `com_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_matiere' THEN `new_view_2`.`option_code`
END) AS `com_matere`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_mode_protec' THEN `new_view_2`.`option_code`
END) AS `com_mode_protec`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_nom_produit' THEN `new_view_2`.`value_string`
END) AS `com_mon_produit`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_photo' THEN `new_view_2`.`file_path`
END) AS `com_photo`,
(CASE `new_view_2`.`attribut_code`
WHEN 'com_poids' THEN `new_view_2`.`metric_data`
END) AS `com_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_ampoule_incluse' THEN `new_view_2`.`value_boolean`
END) AS `elec_ampoule_incluse`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_coef_taxed3e' THEN `new_view_2`.`value_decimal`
END) AS `elec_coef_taxed3e`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_commentaire' THEN `new_view_2`.`value_text`
END) AS `elec_commentaire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_couleur_cable' THEN `new_view_2`.`value_string`
END) AS `elec_couleur_cable`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_couleur_douille' THEN `new_view_2`.`value_string`
END) AS `elec_couleur_douille`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_famille_montage' THEN `new_view_2`.`value_string`
END) AS `elec_famille_montage`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_longueur_cable' THEN `new_view_2`.`metric_data`
END) AS `elec_longueur_cable`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_matiere_douille' THEN `new_view_2`.`option_code`
END) AS `elec_matiere_douille`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_nbre_pile' THEN `new_view_2`.`value_decimal`
END) AS `elec_nbre_pile`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_pav_couleur' THEN `new_view_2`.`value_string`
END) AS `elec_pav_couleur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_pav_diametre' THEN `new_view_2`.`metric_data`
END) AS `elec_pav_diametre`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_pav_hauteur' THEN `new_view_2`.`metric_data`
END) AS `elec_pav_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_piles' THEN `new_view_2`.`option_code`
END) AS `elec_piles`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_piles_fourni' THEN `new_view_2`.`value_boolean`
END) AS `elec_piles_fourni`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_puissance_eco' THEN `new_view_2`.`metric_data`
END) AS `elec_puissance_eco`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_puissance_fluo' THEN `new_view_2`.`metric_data`
END) AS `elec_puissance_fluo`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_puissance_inc' THEN `new_view_2`.`metric_data`
END) AS `elec_puissance_inc`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_taxed3e' THEN `new_view_2`.`option_code`
END) AS `elec_taxed3e`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_transformateur' THEN `new_view_2`.`value_boolean`
END) AS `elec_transformateur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_type_douille' THEN `new_view_2`.`option_code`
END) AS `elec_type_douille`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_type_interrupteur' THEN `new_view_2`.`option_code`
END) AS `elec_type_interrupteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'elec_type_lumiere' THEN `new_view_2`.`option_code`
END) AS `elec_type_lumiere`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_carcasses' THEN `new_view_2`.`value_text`
END) AS `fab_carc_carcasses`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_code_erp' THEN `new_view_2`.`option_code`
END) AS `fab_carc_code_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_code_fournisseur' THEN `new_view_2`.`option_code`
END) AS `fab_carc_code_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_couleur' THEN `new_view_2`.`value_string`
END) AS `fab_carc_couleur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_libelle' THEN `new_view_2`.`value_string`
END) AS `fab_carc_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_prix' THEN `new_view_2`.`data_price`
END) AS `fab_carc_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_carc_ref_fournisseur' THEN `new_view_2`.`value_string`
END) AS `fab_carc_ref_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_code_erp' THEN `new_view_2`.`value_string`
END) AS `fab_cc_code_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_code_fournisseur' THEN `new_view_2`.`option_code`
END) AS `fab_cc_code_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_libelle' THEN `new_view_2`.`value_string`
END) AS `fab_cc_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_prix' THEN `new_view_2`.`data_price`
END) AS `fab_cc_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_ref_fourniseur' THEN `new_view_2`.`value_string`
END) AS `fab_cc_ref_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_cc_type' THEN `new_view_2`.`option_code`
END) AS `fab_cc_type`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_coupe_libelle' THEN `new_view_2`.`value_string`
END) AS `fab_coupe_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_coupe_prix' THEN `new_view_2`.`data_price`
END) AS `fab_coupe_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_code_erp' THEN `new_view_2`.`option_code`
END) AS `fab_fini_code_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_code_fournisseur' THEN `new_view_2`.`option_code`
END) AS `fab_fini_code_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_finitions' THEN `new_view_2`.`value_text`
END) AS `fab_fini_finitions`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_libelle' THEN `new_view_2`.`value_string`
END) AS `fab_fini_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_longueur' THEN `new_view_2`.`metric_data`
END) AS `fab_fini_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_prix' THEN `new_view_2`.`data_price`
END) AS `fab_fini_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_fini_ref_fournisseur' THEN `new_view_2`.`value_string`
END) AS `fab_fini_ref_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_pxrev_cout_standard' THEN `new_view_2`.`data_price`
END) AS `fab_pxrev_cout_standard`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_pxrev_main_oeuvre_cout' THEN `new_view_2`.`value_decimal`
END) AS `fab_pxrev_main_oeuvre_cout`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_pxrev_main_oeuvre_temps' THEN `new_view_2`.`value_decimal`
END) AS `fab_pxrev_main_oeuvre_temps`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_code_erp' THEN `new_view_2`.`option_code`
END) AS `fab_tissu_code_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_code_fournisseur' THEN `new_view_2`.`option_code`
END) AS `fab_tissu_code_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_delai_appro' THEN `new_view_2`.`value_decimal`
END) AS `fab_tissu_delai_appro`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_en_collec_fou' THEN `new_view_2`.`value_boolean`
END) AS `fab_tissu_en_collec_fou`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_fin_suivi_fou' THEN `new_view_2`.`value_boolean`
END) AS `fab_tissu_fin_suivi_fou`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_laize' THEN `new_view_2`.`metric_data`
END) AS `fab_tissu_laize`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_libelle' THEN `new_view_2`.`value_string`
END) AS `fab_tissu_libelle`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_mini_cde' THEN `new_view_2`.`value_decimal`
END) AS `fab_tissu_mini_cde`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_placement_ml' THEN `new_view_2`.`value_decimal`
END) AS `fab_tissu_placement_ml`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_placement_nbr_article' THEN `new_view_2`.`value_decimal`
END) AS `fab_tissu_placement_nbr_article`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_prix' THEN `new_view_2`.`data_price`
END) AS `fab_tissu_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fab_tissu_ref_fournisseur' THEN `new_view_2`.`value_string`
END) AS `fab_tissu_ref_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fsc_essence' THEN `new_view_2`.`option_code`
END) AS `fsc_essence`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fsc_label' THEN `new_view_2`.`option_code`
END) AS `fsc_label`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fsc_percent' THEN `new_view_2`.`value_decimal`
END) AS `fsc_percent`,
(CASE `new_view_2`.`attribut_code`
WHEN 'fsc_type' THEN `new_view_2`.`option_code`
END) AS `fsc_type`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_code_erp' THEN `new_view_2`.`value_string`
END) AS `id_code_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_famille_produit' THEN `new_view_2`.`value_string`
END) AS `id_famille_produit`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_gencod_produit' THEN `new_view_2`.`value_string`
END) AS `id_gencod_prouit`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_nature_produit' THEN `new_view_2`.`option_code`
END) AS `id_nature_produit`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_num_tick_crea' THEN `new_view_2`.`value_string`
END) AS `id_num_tick_crea`,
(CASE `new_view_2`.`attribut_code`
WHEN 'id_vie_produit' THEN `new_view_2`.`option_code`
END) AS `id_vie_produit`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_cable_fourni' THEN `new_view_2`.`value_boolean`
END) AS `imp_cable_fourni`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_colorbox_hauteur' THEN `new_view_2`.`metric_data`
END) AS `imp_colorbox_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_colorbox_largeur' THEN `new_view_2`.`metric_data`
END) AS `imp_colorbox_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_colorbox_longueur' THEN `new_view_2`.`metric_data`
END) AS `imp_colorbox_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_commentaire' THEN `new_view_2`.`value_text`
END) AS `imp_commentaire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_conditionnement' THEN `new_view_2`.`option_code`
END) AS `imp_conditionnement`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_customs_code' THEN `new_view_2`.`option_code`
END) AS `imp_customs_code`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_date_prev_echantillon' THEN `new_view_2`.`value_date`
END) AS `imp_date_prev_echantillon`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_delai_production' THEN `new_view_2`.`option_code`
END) AS `imp_delai_production`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_description' THEN `new_view_2`.`value_string`
END) AS `imp_description`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ech_arrive' THEN `new_view_2`.`value_date`
END) AS `imp_ech_arrive`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ech_commentaire' THEN `new_view_2`.`value_text`
END) AS `imp_ech_commentaire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ech_demande' THEN `new_view_2`.`value_date`
END) AS `imp_ech_demande`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ech_destina' THEN `new_view_2`.`value_string`
END) AS `imp_ech_destina`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ech_transport' THEN `new_view_2`.`option_code`
END) AS `imp_ech_transport`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_etiq_energ' THEN `new_view_2`.`file_path`
END) AS `imp_etiq_energ`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_etiq_hauteur' THEN `new_view_2`.`metric_data`
END) AS `imp_etiq_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_etiq_largeur' THEN `new_view_2`.`metric_data`
END) AS `imp_etiq_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_etiquette' THEN `new_view_2`.`value_boolean`
END) AS `imp_etiquette`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_fob' THEN `new_view_2`.`option_code`
END) AS `imp_fob`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_fournisseur' THEN `new_view_2`.`value_string`
END) AS `imp_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_fournisseur_adresse' THEN `new_view_2`.`value_string`
END) AS `imp_fournisseur_adresse`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_fournisseur_coordonnees' THEN `new_view_2`.`value_string`
END) AS `imp_fournisseur_coordonnees`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_fournisseur_erp' THEN `new_view_2`.`option_code`
END) AS `imp_fournisseur_erp`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_hauteur' THEN `new_view_2`.`metric_data`
END) AS `imp_inner_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_largeur' THEN `new_view_2`.`metric_data`
END) AS `imp_inner_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_longueur' THEN `new_view_2`.`metric_data`
END) AS `imp_inner_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_poids' THEN `new_view_2`.`metric_data`
END) AS `imp_inner_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_qte' THEN `new_view_2`.`value_decimal`
END) AS `imp_inner_qte`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_inner_recyclable' THEN `new_view_2`.`value_boolean`
END) AS `imp_inner_recyclable`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_libel_art_fou' THEN `new_view_2`.`value_string`
END) AS `imp_libel_art_fou`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_hauteur' THEN `new_view_2`.`metric_data`
END) AS `imp_master_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_largeur' THEN `new_view_2`.`metric_data`
END) AS `imp_master_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_longueur' THEN `new_view_2`.`metric_data`
END) AS `imp_master_longeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_poids' THEN `new_view_2`.`metric_data`
END) AS `imp_master_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_quantite_par_carton' THEN `new_view_2`.`value_decimal`
END) AS `imp_master_quantite_par_carton`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_master_recyclable' THEN `new_view_2`.`value_boolean`
END) AS `imp_master_recyclable`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_monnaie' THEN `new_view_2`.`option_code`
END) AS `imp_monnaie`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_moq' THEN `new_view_2`.`value_decimal`
END) AS `imp_moq`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_packing' THEN `new_view_2`.`option_code`
END) AS `imp_packing`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_prix' THEN `new_view_2`.`data_price`
END) AS `imp_prix`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_prix_validite' THEN `new_view_2`.`value_string`
END) AS `imp_prix_validite`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_produit_type' THEN `new_view_2`.`option_code`
END) AS `imp_produit_type`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_puissance' THEN `new_view_2`.`option_code`
END) AS `imp_puissance`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_pim_valuescbag_hauteur' THEN `new_view_2`.`metric_data`
END) AS `imp_pim_valuescbag_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_pim_valuescbag_largeur' THEN `new_view_2`.`metric_data`
END) AS `imp_pim_valuescbag_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_pim_valuescbag_longueur' THEN `new_view_2`.`metric_data`
END) AS `imp_pim_valuescbag_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_quotation_date' THEN `new_view_2`.`value_string`
END) AS `imp_quotation_date`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_ref_fournisseur' THEN `new_view_2`.`value_string`
END) AS `imp_ref_fournisseur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_terme_paiement' THEN `new_view_2`.`option_code`
END) AS `imp_terme_paiement`,
(CASE `new_view_2`.`attribut_code`
WHEN 'imp_urg_echantillon' THEN `new_view_2`.`value_boolean`
END) AS `imp_urg_echantillon`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_h_max' THEN `new_view_2`.`metric_data`
END) AS `lpr_h_max`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_h_min' THEN `new_view_2`.`metric_data`
END) AS `lpr_h_min`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_long_flex' THEN `new_view_2`.`metric_data`
END) AS `lpr_long_flex`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_nbr_rotule' THEN `new_view_2`.`value_decimal`
END) AS `lpr_nbr_rotule`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_pres_flex' THEN `new_view_2`.`value_boolean`
END) AS `lpr_pres_flex`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_pres_rotule' THEN `new_view_2`.`value_boolean`
END) AS `lpr_pres_rotule`,
(CASE `new_view_2`.`attribut_code`
WHEN 'lpr_telescopic' THEN `new_view_2`.`value_boolean`
END) AS `lpr_telescopic`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_boule_diametre' THEN `new_view_2`.`metric_data`
END) AS `ol_boule_diametre`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_boule_ecartement' THEN `new_view_2`.`metric_data`
END) AS `ol_boule_ecartement`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_boule_nombre' THEN `new_view_2`.`value_decimal`
END) AS `ol_boule_nombre`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_hauteur' THEN `new_view_2`.`metric_data`
END) AS `ol_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_largeur' THEN `new_view_2`.`metric_data`
END) AS `ol_largeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_leading_wire' THEN `new_view_2`.`metric_data`
END) AS `ol_leading_wire`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_longueur' THEN `new_view_2`.`metric_data`
END) AS `ol_longeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'ol_poids' THEN `new_view_2`.`metric_data`
END) AS `ol_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_couleur' THEN `new_view_2`.`value_string`
END) AS `pied_couleur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_diametre' THEN `new_view_2`.`metric_data`
END) AS `pied_diametre`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_entretoise' THEN `new_view_2`.`value_boolean`
END) AS `pied_entretoise`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_hauteur' THEN `new_view_2`.`metric_data`
END) AS `pied_hauteur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_poids' THEN `new_view_2`.`metric_data`
END) AS `pied_poids`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_taille_entretoise' THEN `new_view_2`.`metric_data`
END) AS `pied_taille_entretoise`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_tige_diametre' THEN `new_view_2`.`metric_data`
END) AS `pied_tige_diametre`,
(CASE `new_view_2`.`attribut_code`
WHEN 'pied_tige_longueur' THEN `new_view_2`.`metric_data`
END) AS `pied_tige_longueur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'sku' THEN `new_view_2`.`value_string`
END) AS `sku`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_couleur_tete' THEN `new_view_2`.`value_string`
END) AS `spot_couleur_tete`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_hauteur_tete' THEN `new_view_2`.`metric_data`
END) AS `spot_hauteur_tete`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_largeur_tete' THEN `new_view_2`.`metric_data`
END) AS `spot_largeur_tete`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_matiere_tete' THEN `new_view_2`.`value_string`
END) AS `spot_matiere_tete`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_nbre_tete' THEN `new_view_2`.`value_decimal`
END) AS `spot_nbre_tete`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_profondeur' THEN `new_view_2`.`metric_data`
END) AS `spot_profondeur`,
(CASE `new_view_2`.`attribut_code`
WHEN 'spot_type_support' THEN `new_view_2`.`option_code`
END) AS `spot_type_support`,
(CASE `new_view_2`.`attribut_code`
WHEN 'tiss_composition' THEN `new_view_2`.`value_string`
END) AS `tiss_composition`
FROM
`new_view_2`
GROUP BY `new_view_2`.`entity_id` |
