Get the data of the specified condition under the txt file

clipboard.png
if my condition is this date and time, and what I want is in xml format, and that, the value of type is the variable I passed in.
for example, how do I get this data when I want a type of 0 in 20181010 xml format?

Aug.10,2021

cat 
grep 
awk
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e458e2-44b51.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e458e2-44b51.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?