SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa'

---

SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa' AND `a`.`TW_BLOK` = '3' AND `a`.`TW_GRT_ID` = '28' AND `a`.`TW_NAZWA` LIKE '%star%' AND `a`.`TW_NAZWA` LIKE '%maker%'

---

SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa'

---

SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa' AND `a`.`TW_BLOK` = '5' AND `a`.`TW_GRT_ID` = '28' AND `a`.`TW_NAZWA` LIKE '%star%' AND `a`.`TW_NAZWA` LIKE '%maker%'

---

SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa'

---

SELECT a.TW_SYMBOL,a.TW_GRUBOSC,a.TW_OPIS,a.TW_NAZWA,a.TW_TYP_ID,a.TW_BLOK,a.TW_UWAGI,a.TW_ID,a.TW_SS_ID,c.MAG_NAZWA as warehouse,b.ST_JM as jm,b.ST_STAN as stan,d.SS_NAZWA_PL as status,d.SS_ID as statusid,b.ST_REZERWACJA as reservations,a.TW_CENA_SKLEP_BRUTTO FROM `#__towar` AS `a` INNER JOIN `#__towar_stan` AS `b` ON (`a`.`TW_ID` = `b`.`ST_TW_ID` AND TW_TYP_ID=ST_TW_TYP_ID ) INNER JOIN `#__sl_magazyn` AS `c` ON (`b`.`ST_MAG_ID` = `c`.`MAG_ID`) INNER JOIN `#__towar_morderstatus` AS `d` ON (`a`.`TW_SS_ID` = `d`.`SS_ID`) WHERE `a`.`TW_NAZWA` = 'STAR MAKER by Mac Stopa' AND `a`.`TW_BLOK` = '6' AND `a`.`TW_GRT_ID` = '28' AND `a`.`TW_NAZWA` LIKE '%star%' AND `a`.`TW_NAZWA` LIKE '%maker%'

---