//

SELECT `ProductsAttributes`.`id`, `ProductsAttributes`.`product_id`, `ProductsAttributes`.`attribute_id`, `ProductsAttributes`.`prio`, `Products`.`id` AS `Products_id`, `Products`.`name` AS `Products_name`, `Products`.`description_l1` AS `Products_description_l1`, `Products`.`description_l2` AS `Products_description_l2`, `Products`.`description_l3` AS `Products_description_l3`, `Products`.`createdon` AS `Products_createdon`, `Products`.`createdby` AS `Products_createdby`, `Products`.`editedon` AS `Products_editedon`, `Products`.`editedby` AS `Products_editedby`, `Products`.`deleted` AS `Products_deleted`, `Products`.`deletedon` AS `Products_deletedon`, `Products`.`deletedby` AS `Products_deletedby`, `Products`.`published` AS `Products_published`, `Products`.`publishedon` AS `Products_publishedon`, `Products`.`publishedby` AS `Products_publishedby`, `Attributes`.`id` AS `Attributes_id`, `Attributes`.`name` AS `Attributes_name`, `Attributes`.`type_id` AS `Attributes_type_id` FROM `vdb_products_attributes` AS `ProductsAttributes` LEFT JOIN `vdb_products` `Products` ON `ProductsAttributes`.`product_id` = `Products`.`id` LEFT JOIN `vdb_attributes` `Attributes` ON `ProductsAttributes`.`attribute_id` = `Attributes`.`id` WHERE `Products`.`name` = '' GROUP BY Products.id

System Detail

Schnittzeichnung

Dieses Produkt gehört zu folgenden Systemen

Anwendungsbeispiele für dieses Produkt