So it looks like it was a simple punctuation, works in mysql but not in xenforo. So got that working but now got another question.

I'm in a nutshell, I'm trying to grab a Profile field from xenforo(which I do above), take each users profile field and loop it through another websites API, grab data from that and use it on a page on Xenforo. So to reduce load on the server I figured i'd schedule it to update every couple of minutes. Without knowing how Xen's Cron functions work Should I

Create a normal php file, have the webserver's cron management handle the data, upload it to a new table in MYSQL and then try to pull that data from xenforo.

Use Xenforo's cron management to archieve the data and then pull it back in when needed.