SELECT *
, IF(COUNT(pa.id) IS NULL, 0, COUNT(pa.id)) kol
, SUM(IF(pa.pa_ga_id_search > 0 OR pa.pa_art_id = -2, 1, 0)) link
, ROUND(IF(COUNT(pa.id) IS NULL, 0, SUM(IF(pa.pa_ga_id_search > 0 OR pa.pa_art_id = -2, 1, 0)) / COUNT(pa.id)), 2) link_proc
FROM brand_all ba
LEFT JOIN prices_all pa ON ba.id = pa.brand_id AND pa.avalaible_gen IN (0,1)
WHERE ba.id IN (
27,
80,
149,
171,
192,
278,
331,
340,
408,
542,
580,
632,
653,
654,
758,
915,
954,
975,
1104,
1130,
1174,
1258,
1286,
1447,
1587,
1602,
1645,
1654,
1655,
1810,
1838,
1852,
1859,
1861,
1893,
1903,
1905,
1963,
1995,
2029,
2083,
2098,
2201,
2215,
2237,
2246,
2277,
2394,
2396,
2410,
2429,
2460,
2567,
2568,
2584,
2604,
2609,
2612,
2627,
2633,
2653,
2704,
2726,
2732,
2742,
2796,
2857,
2877,
2929,
3072,
3190,
10241,
10707,
11161,
11468,
11469,
11481,
11482,
11666,
12030,
12031,
12032,
12033,
12034,
12035,
12036
)

AND (pa.pa_ga_id IS NULL OR pa.pa_ga_id IN (
938,
41313,
41314,
41315,
41316,
41317,
41318,
41319,
41352,
41382,
41383,
41399,
41411,
41426,
41435,
41439,
298,
62,
2504,
54293,
54294,
54295,
54296,
54297,
54298,
54299,
54300,
54397,
54400,
54406,
54416,
54425,
54427,
54428,
54430,
54434,
54436,
54460,
54461,
54462,
54476,
54484,
54491,
54492,
54493,
54507,
54515,
54522,
54523,
54530,
54537,
54540,
1488,
1914,
1915,
2809,
2810,
3392,
1377,
14,
1373,
1374,
1375,
712,
2872,
703,
2870,
289,
2484,
1560,
50130,
50132,
50133,
50134,
50135,
50136,
50137,
50138,
50139,
50140,
53977,
54041,
54073,
54089,
54104,
54160,
54191,
54206,
54213,
259,
3175,
3328,
30379,
30381,
30382,
30383,
30384,
30385,
30386,
30387,
30388,
30548,
30578,
30607,
30618,
30622,
30625,
794,
2903,
2801,
41699,
1191,
901,
4370,
449,
41247,
41248,
41249,
41250,
41251,
41252,
41283,
41284,
41292,
41299,
23,
2476,
3257,
3393,
531,
3331,
3232,
391,
2492,
291,
89,
3336,
88,
3335
))
GROUP BY ba.id
ORDER BY kol DESC