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

Fiches Techniques Imprimantes Algérie