select
service_125.date_creation ,
3771 as id_grande_famille ,
228814 as id_comportement ,
18 as has_comparatifs ,
'prints' as root ,
'Imprimantes' as libelle_famille ,
53171 as id_famille ,
125 as id_catalogue ,
-1 as has_sous_famille ,
service_125.id_dep_933 as id_sous_famille ,
'Imprimantes' as libelle_sous_famille ,
'' as root_sous_famille ,
service_125.id_schema_700 as libelle_modele,
service_125.id_schema_702 as libelle_grande_photo,
service_125.id_schema_703 as libelle_prix,
728 as dep_1 ,
service_125.id_dep_728 as id_dep_1_hub ,
service_dep_728.id_schema_1134 as dep_1_hub,
'' as dep_1_hub_libelle ,
'' as dep_1_hub_sufix ,
'Format' as dep_1_libelle ,
523 as dep_2 ,
service_125.id_dep_523 as id_dep_2_hub ,
service_dep_523.id_schema_755 as dep_2_hub,
'' as dep_2_hub_libelle ,
'' as dep_2_hub_sufix ,
'Technologie' as dep_2_libelle ,
572 as dep_3 ,
service_125.id_dep_572 as id_dep_3_hub ,
service_dep_572.id_schema_809 as dep_3_hub,
'' as dep_3_hub_libelle ,
'' as dep_3_hub_sufix ,
'Type' as dep_3_libelle ,
service_11.id_schema_29 as libelle_marque ,
service_11.id_service as id_marque,
494 as id_dep_marque ,
service_125.id_service as cle
from
service_125
inner JOIN service_11 ON
service_125.id_dep_494= service_11.id_service
left join service_208 as service_dep_728 on
service_125.id_dep_728=service_dep_728.id_service
left join service_139 as service_dep_523 on
service_125.id_dep_523=service_dep_523.id_service
left join service_162 as service_dep_572 on
service_125.id_dep_572=service_dep_572.id_service where service_125.actif=1 and service_125.id_dep_933=53171 and service_125.id_dep_494=5562
order by date_creation desc , libelle_marque , libelle_modele limit 0,40