I’ve been attempting to make sense of why the heck WordPress doesn’t export pages in their fancy plugin. But they don’t so I figured this craziness out. It actually worked for what I wanted it to do. This probably won’t help anyone but it helped me learning something new and overcome an ever present challenge.
WHERE `post_type` = CONVERT( _utf8 ‘page’
USING latin1 )
LIMIT 0 , 30