Accessori idraulici
MySQL
User 'leopompevcmvc' has exceeded the 'max_questions' resource (current value: 64000)
Query
select `ref`, `tradeRef`, `branchId`, `name`, ifNull((select expression from language│translation where translationId = `accessory`.`name` && languageId in('it', 'en', 'fr') && expression != '' order by field(languageId, 'it', 'en', 'fr') limit 1), "") as `[TR]name`, `tradeName`, ifNull((select expression from language│translation where translationId = `accessory`.`tradeName` && languageId in('it', 'en', 'fr') && expression != '' order by field(languageId, 'it', 'en', 'fr') limit 1), "") as `[TR]tradeName`, `supplierName`, ifNull((select expression from language│translation where translationId = `accessory`.`supplierName` && languageId in('it', 'en', 'fr') && expression != '' order by field(languageId, 'it', 'en', 'fr') limit 1), "") as `[TR]supplierName`, `description`, ifNull((select expression from language│translation where translationId = `accessory`.`description` && languageId in('it', 'en', 'fr') && expression != '' order by field(languageId, 'it', 'en', 'fr') limit 1), "") as `[TR]description`, `details`, ifNull((select expression from language│translation where translationId = `accessory`.`details` && languageId in('it', 'en', 'fr') && expression != '' order by field(languageId, 'it', 'en', 'fr') limit 1), "") as `[TR]details`, `barcode`, `publicPrice`, `floorPrice`, `theoreticalCostPrice`, `weight`, `remiseId`, `image`, `order`, `hidden`
from `accessory`
where branchId = 11
order by `order`
