SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '41' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '42' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '48' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '49' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '43' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '44' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '50' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '46' ORDER BY layer.orderNr ASC;

SELECT layer.*, moduledata.id AS moduleid FROM layer LEFT OUTER JOIN moduledata ON moduledata.name = SUBSTRING(layer.output,1,INSTR(layer.output,'/') - 1) WHERE layer.parentID = '47' ORDER BY layer.orderNr ASC;