stock lists

I am looking for two querries (to use them in phpMyAdmin): 1.? ? ? to get a stocklist with details, how many and which goods are at a specific stock position 2.? ? ? to get a stocklist, at which stock position are goods ? ? All together you have to use 5 tables (MySQL). The list should be able to copy to MS-Excel (e.g. .csv). Because the tables are in german language, I will translate the names to english