SELECT b.id_brand AS bid, b.name,
b.sys_name AS sysname,
cbef.type,
ft.name_ru AS type_name,
ft.sysname AS type_sysname,
SUM(fs.views) AS views,
SUM(fs.loads) AS loads,
IF(mt.id IS NOT NULL, 1, 0) AS is_onmain
FROM cat_dev.brands AS b
INNER JOIN fixdevice.fd_cats_brands_equips_files AS cbef ON cbef.bid = b.id_brand
INNER JOIN fixdevice.fd_files_types AS ft ON ft.L = cbef.type
LEFT JOIN fd_files_stats AS fs ON fs.fid = cbef.fid AND fs.type = cbef.type
LEFT JOIN fd_mainpage_tuning AS mt ON mt.id = b.id_brand AND mt.type_c = 'B' AND mt.type = cbef.type
WHERE ft.onmain = 1
GROUP BY cbef.bid, cbef.type
ORDER BY is_onmain DESC, loads DESC, views DESC
LIMIT 55
Производители и устройства начинающиеся на букву L: LaCie Мониторы Драйверы, Lada Автомагнитолы Инструкции, Lanzar Автомагнитолы Инструкции :: FixDevice.Ru
