This version does not have the out of order problem...
[{"id":"a78eaae2.ed1fe8","type":"inject","z":"c9ca6ac7.25b568","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"IAQ/0999/temperature","payload":"26.5","payloadType":"num","x":650,"y":60,"wires":[["fe93ea10.7aec78"]]},{"id":"fe93ea10.7aec78","type":"join","z":"c9ca6ac7.25b568","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"5","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":870,"y":140,"wires":[["186dd683.c907a9","7510f528.68649c"]]},{"id":"186dd683.c907a9","type":"debug","z":"c9ca6ac7.25b568","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1030,"y":140,"wires":[]},{"id":"7510f528.68649c","type":"function","z":"c9ca6ac7.25b568","name":"INSERT Data","func":"temp = msg.payload[\"IAQ/0999/temperature\"];\nhum = msg.payload[\"IAQ/0999/humidity\"];\npm25 = msg.payload[\"IAQ/0999/pm25\"];\nco2 = msg.payload[\"IAQ/0999/co2\"];\nif (msg.payload[\"IAQ/0999/count\"] == \"6\") {\n msg.topic = `INSERT INTO AP20999(value1, value2, value3,value4) VALUES(${pm25},${temp},${hum},${co2})`;\n return msg;\n}\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1040,"y":200,"wires":[["f1c8a200.0841a"]]},{"id":"649d8a14.5ca094","type":"inject","z":"c9ca6ac7.25b568","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"IAQ/0999/count","payload":"6","payloadType":"num","x":620,"y":220,"wires":[["fe93ea10.7aec78"]]},{"id":"d9cfd990.ab8d18","type":"inject","z":"c9ca6ac7.25b568","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"IAQ/0999/co2","payload":"0.0123","payloadType":"num","x":640,"y":180,"wires":[["fe93ea10.7aec78"]]},{"id":"9b7a804c.b5a02","type":"inject","z":"c9ca6ac7.25b568","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"IAQ/0999/pm25","payload":"12345","payloadType":"num","x":640,"y":140,"wires":[["fe93ea10.7aec78"]]},{"id":"954f23b0.5f66f","type":"inject","z":"c9ca6ac7.25b568","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"IAQ/0999/humidity","payload":"100.56","payloadType":"num","x":650,"y":100,"wires":[["fe93ea10.7aec78"]]},{"id":"f1c8a200.0841a","type":"debug","z":"c9ca6ac7.25b568","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"topic","targetType":"msg","statusVal":"payload","statusType":"auto","x":1040,"y":240,"wires":[]}]
