SELECT farmako.EMPORIKHON, farmako.KOD_FARMAK, farmako.MORFHSKEYA, farmako.drastiki, nors_sistatika.typos_skeyasmatos, nors_sistatika.cat_text, nors_skeyasmata.comments, nors_skeyasmata.category, nors_skeyasmata.plithintikos FROM farmako, `nors_skeyasmata`, `nors_sistatika` where farmako.EDR_COD_KAT ="RO" AND nors_sistatika.category = "AL" AND `nors_sistatika`.name = farmako.MORFHSKEYA AND farmako.EDR_COD_KAT = `nors_skeyasmata`.code_name ORDER BY farmako.drastiki, farmako.EMPORIKHON