Skip to main content

SQL Queries

List of all specialist dealers of the "i&M" group​

select `address`.`zip`           as 'PLZ',
       `address`.`city`          as 'Ort',
       `store`.`customer_number` as 'Kundenummer',
       `store`.`name`            as 'Bezeichnung'
from `tx_fhstore_domain_model_store` `store`
         join `tx_fhstore_domain_model_address` `address` on `store`.`address` = `address`.`uid`
where `store`.`family_brand` = 1
  and `store`.`deleted` = 0
  and `store`.`hidden` = 0;