Cannot Add Advanced mySQL Query

Hello, All -

I've created a fairly complex mySQL query to generate a list in a CMSB editor. However, although the thing works perfectly in phpMyAdmin I can't even set it up in CMSB.

I paste the code into the field and hit save only to be rewarded with an error message:

There was an error sending the request! (404 Not Found)

The code for the  query is:

SELECT 
  cms_pages.name AS LABELS, 
  CONCAT( CAST(cms_settings.indexPage AS CHAR), "?p=", CAST(cms_pages.num AS CHAR) ) AS VALUES
  FROM `cms_settings`, `cms_pages` 
  WHERE cms_pages.hidden != 1

It should produce a result like this: /index.php?p=num (where num is the number of a page)

It works fine in phpMyAdmin.

I'm using CMSB v2.52

:0/

Perch