[MYSQL] złożone zapytanie Opcje

[topcio]

Witajcie
Proszę o pomoc.

Mam tabelę, wygląda mniej więcej tak

ID COL_1 COL_2 COL_3 COL_4
1 TYP_1 NAZWA_1 TEXT_1 DANE_1
2 TYP_1 NAZWA_1 TEXT_2 DANE_2
3 TYP_1 NAZWA_1 TEXT_3 DANE_3
4 TYP_1 NAZWA_1 TEXT_4 DANE_4
5 TYP_2 NAZWA_2 TEXT_1 DANE_5
6 TYP_2 NAZWA_2 TEXT_2 DANE_6
7 TYP_2 NAZWA_2 TEXT_3 DANE_7
8 TYP_2 NAZWA_2 TEXT_4 DANE_8
9 TYP_1 NAZWA_3 TEXT_1 DANE_9
10 TYP_1 NAZWA_3 TEXT_2 DANE_10
11 TYP_1 NAZWA_3 TEXT_3 DANE_11
12 TYP_1 NAZWA_3 TEXT_4 DANE_12
13 TYP_2 NAZWA_4 TEXT_1 DANE_13
14 TYP_2 NAZWA_4 TEXT_2 DANE_14
15 TYP_2 NAZWA_4 TEXT_3 DANE_15
16 TYP_2 NAZWA_4 TEXT_4 DANE_16

Potrzebuję zrobić takie zapytanie z PHP aby:
1. Wybrać np. tylko TYP_1
2. Dla TYP_1 wybrać wszystko z COL_2, COL_3, COL_4
3. Wyświetlić to jako jeden wiersz, aby w efekcie końcowym uzyskać

TYP_1, NAZWA_1, TEXT_1 - DANE_1, TEXT_2 - DANE_2, TEXT_3 - DANE_3, TEXT_4 - DANE_4,
TYP_1, NAZWA_9, TEXT_1 - DANE_9, TEXT_2 - DANE_10, TEXT_3 - DANE_11, TEXT_4 - DANE_12,

Z góry dzięki za pomoc

[topcio]

do wszystkich bonusów, które dla każdego grade są inne
np mieć tak
[Common]_Bonus% [Uncommon]_Bonus% [Rare]_Bonus%


chyba po prost zrorganizuję tabelę

pomęczyłem trochę i doszedłem co i jak
I powiem Ci, że jestem z siebie dumny

[SQL] pobierz, plaintext 
SELECT * FROM (
    SELECT Name, Type, Player_Level,
    GROUP_CONCAT(Bonus_Army_ATK SEPARATOR ';') AS Bonus_Army_ATK, 
    GROUP_CONCAT(Bonus_Army_Capacity SEPARATOR ';') AS Bonus_Army_Capacity, 
    GROUP_CONCAT(Bonus_Army_DEF SEPARATOR ';') AS Bonus_Army_DEF,
    GROUP_CONCAT(Bonus_Army_Max_HP SEPARATOR ';') AS Bonus_Army_Max_HP,
    GROUP_CONCAT(Bonus_Cavalry_ATK SEPARATOR ';') AS Bonus_Cavalry_ATK,
    GROUP_CONCAT(Bonus_Cavalry_DEF SEPARATOR ';') AS Bonus_Cavalry_DEF,
    GROUP_CONCAT(Bonus_Cavalry_Max_HP SEPARATOR ';') AS Bonus_Cavalry_Max_HP,
    GROUP_CONCAT(Bonus_Construction_Speed SEPARATOR ';') AS Bonus_Construction_Speed,
    GROUP_CONCAT(Bonus_Enemy_Army_DEF_Debuff SEPARATOR ';') AS Bonus_Enemy_Army_DEF_Debuff,
    GROUP_CONCAT(Bonus_Enemy_Army_Max_HP_Debuff SEPARATOR ';') AS Bonus_Enemy_Army_Max_HP_Debuff,
    GROUP_CONCAT(Bonus_Energy_Saver SEPARATOR ';') AS Bonus_Energy_Saver,
    GROUP_CONCAT(Bonus_Familiar_Skill_EXP_Boost SEPARATOR ';') AS Bonus_Familiar_Skill_EXP_Boost,
    GROUP_CONCAT(Bonus_Familiar_Training_Level_EXP_Boost SEPARATOR ';') AS Bonus_Familiar_Training_Level_EXP_Boost,
    GROUP_CONCAT(Bonus_Food_Production_Rate SEPARATOR ';') AS Bonus_Food_Production_Rate,
    GROUP_CONCAT(Bonus_Forging_Speed SEPARATOR ';') AS Bonus_Forging_Speed,
    GROUP_CONCAT(Bonus_Gold_Production_Rate SEPARATOR ';') AS Bonus_Gold_Production_Rate,   
    GROUP_CONCAT(Bonus_Infantry_ATK SEPARATOR ';') AS Bonus_Infantry_ATK,
    GROUP_CONCAT(Bonus_Infantry_DEF SEPARATOR ';') AS Bonus_Infantry_DEF,
    GROUP_CONCAT(Bonus_Infantry_Max_HP SEPARATOR ';') AS Bonus_Infantry_Max_HP,
    GROUP_CONCAT(Bonus_Max_Energy SEPARATOR ';') AS Bonus_Max_Energy,
    GROUP_CONCAT(Bonus_Merging_Speed_Boost_Pacts SEPARATOR ';') AS Bonus_Merging_Speed_Boost_Pacts,
    GROUP_CONCAT(Bonus_Merging_Speed_Boost_Skillstones SEPARATOR ';') AS Bonus_Merging_Speed_Boost_Skillstones,
    GROUP_CONCAT(Bonus_Monster_Hunt_DMG_Boost SEPARATOR ';') AS Bonus_Monster_Hunt_DMG_Boost,
    GROUP_CONCAT(Bonus_Monster_Hunt_Starting_MP SEPARATOR ';') AS Bonus_Monster_Hunt_Starting_MP,
    GROUP_CONCAT(Bonus_Monster_Hunt_Travel_Speed SEPARATOR ';') AS Bonus_Monster_Hunt_Travel_Speed,
    GROUP_CONCAT(Bonus_Ore_Production_Rate SEPARATOR ';') AS Bonus_Ore_Production_Rate,
    GROUP_CONCAT(Bonus_Pack_Attack SEPARATOR ';') AS Bonus_Pack_Attack,
    GROUP_CONCAT(Bonus_Player_EXP_Boost SEPARATOR ';') AS Bonus_Player_EXP_Boost,
    GROUP_CONCAT(Bonus_Ranged_ATK SEPARATOR ';') AS Bonus_Ranged_ATK,
    GROUP_CONCAT(Bonus_Ranged_DEF SEPARATOR ';') AS Bonus_Ranged_DEF,    
    GROUP_CONCAT(Bonus_Ranged_Max_HP SEPARATOR ';') AS Bonus_Ranged_Max_HP,
    GROUP_CONCAT(Bonus_Reduced_Upkeep SEPARATOR ';') AS Bonus_Reduced_Upkeep,
    GROUP_CONCAT(Bonus_Research_Speed SEPARATOR ';') AS Bonus_Research_Speed,
    GROUP_CONCAT(Bonus_Resource_Gathering_Speed SEPARATOR ';') AS Bonus_Resource_Gathering_Speed,
    GROUP_CONCAT(Bonus_Siege_Engine_ATK SEPARATOR ';') AS Bonus_Siege_Engine_ATK,
    GROUP_CONCAT(Bonus_Siege_Engine_DEF SEPARATOR ';') AS Bonus_Siege_Engine_DEF,    
    GROUP_CONCAT(Bonus_Siege_Engine_Max_HP SEPARATOR ';') AS Bonus_Siege_Engine_Max_HP,
    GROUP_CONCAT(Bonus_Stone_Production_Rate SEPARATOR ';') AS Bonus_Stone_Production_Rate,
    GROUP_CONCAT(Bonus_Timber_Production_Rate SEPARATOR ';') AS Bonus_Timber_Production_Rate,
    GROUP_CONCAT(Bonus_Training_Speed SEPARATOR ';') AS Bonus_Training_Speed,
    GROUP_CONCAT(Bonus_Trap_ATK SEPARATOR ';') AS Bonus_Trap_ATK,    
    GROUP_CONCAT(Bonus_Trap_DEF SEPARATOR ';') AS Bonus_Trap_DEF,
    GROUP_CONCAT(Bonus_Trap_Max_HP SEPARATOR ';') AS Bonus_Trap_Max_HP,
    GROUP_CONCAT(Bonus_Travel_Speed SEPARATOR ';') AS Bonus_Travel_Speed,
    GROUP_CONCAT(Bonus_Wall_DEF_Boost SEPARATOR ';') AS Bonus_Wall_DEF_Boost
    FROM Equipment GROUP BY Name) AS T WHERE Type = 'Helmet'
[SQL] pobierz, plaintext