Array
(
[PHP_FCGI_MAX_REQUESTS] => 500
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 0
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /d/117/Customise_my_own.html
[SCRIPT_URI] => http://www.mrflag.com/d/117/Customise_my_own.html
[HTTP_X_CC_ID] => ccc04-01
[HTTP_IF_MODIFIED_SINCE] => Fri, 02 Apr 2010 13:55:13 GMT
[HTTP_HOST] => www.mrflag.com
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_CONNECTION] => close
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_PRAGMA] => no-cache
[HTTP_COOKIE] => PHPSESSID=a54c85b7f9a137d5da147361cd3f7d44
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 67.23.46.233
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.114
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 10248
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=117
[REQUEST_URI] => /d/117/Customise_my_own.html
[SCRIPT_NAME] => /d/117/Customise_my_own.html
[PHP_SELF] => /d/117/Customise_my_own.html
[REQUEST_TIME] => 1283457735
[argv] => Array
(
[0] => doc=117
)
[argc] => 1
[db_cache] => Array
(
[SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #61
)
[q] => Array
(
[0] => SELECT document_id, document_title, document_meta_title, document_meta_description, document_meta_subject, document_folder, document_order, document_template, document_visible, document_protected FROM cms_documents WHERE document_id = 117 AND document_deleted = 'N' LIMIT 1
[1] => SELECT relationship_id, relationship_originator, relationship_recipient, relationship_type, relationship_medium, relationship_lang FROM cms_documents_relationships WHERE relationship_originator = '117'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 117 AND request_date = CURDATE()
[3] => SELECT revision_id, revision_document_id, revision_author, revision_live, revision_dead, revision_modified, revision_publish_status, revision_lock_status, revision_visible FROM cms_revisions WHERE revision_document_id = 117 AND revision_visible = 1 AND revision_live < NOW() AND revision_dead > NOW() AND revision_publish_status != 0 AND revision_deleted = 'N' ORDER BY revision_id DESC LIMIT 1
[4] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[5] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalKeywords' AND coc.choice_selected = '1'
[6] => SELECT template_id, template_content, template_title, template_description FROM cms_documents_templates WHERE template_id = 2 LIMIT 1
[7] => SELECT box_id, box_content FROM cms_revisions_boxes WHERE box_revision_id = 117 AND box_document_id = 117
[8] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'Basket'
[9] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductDisplay'
[10] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductSearch'
[11] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_id = 554 LIMIT 1
[12] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[13] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_parent_id = 554 AND category_visible = 'Y' ORDER BY category_title ASC
[14] => SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Sort By... Array
(
[PHP_FCGI_MAX_REQUESTS] => 500
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 0
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /d/117/Customise_my_own.html
[SCRIPT_URI] => http://www.mrflag.com/d/117/Customise_my_own.html
[HTTP_X_CC_ID] => ccc04-01
[HTTP_IF_MODIFIED_SINCE] => Fri, 02 Apr 2010 13:55:13 GMT
[HTTP_HOST] => www.mrflag.com
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_CONNECTION] => close
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_PRAGMA] => no-cache
[HTTP_COOKIE] => PHPSESSID=a54c85b7f9a137d5da147361cd3f7d44
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 67.23.46.233
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.114
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 10248
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=117
[REQUEST_URI] => /d/117/Customise_my_own.html
[SCRIPT_NAME] => /d/117/Customise_my_own.html
[PHP_SELF] => /d/117/Customise_my_own.html
[REQUEST_TIME] => 1283457735
[argv] => Array
(
[0] => doc=117
)
[argc] => 1
[db_cache] => Array
(
[SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #61
)
[q] => Array
(
[0] => SELECT document_id, document_title, document_meta_title, document_meta_description, document_meta_subject, document_folder, document_order, document_template, document_visible, document_protected FROM cms_documents WHERE document_id = 117 AND document_deleted = 'N' LIMIT 1
[1] => SELECT relationship_id, relationship_originator, relationship_recipient, relationship_type, relationship_medium, relationship_lang FROM cms_documents_relationships WHERE relationship_originator = '117'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 117 AND request_date = CURDATE()
[3] => SELECT revision_id, revision_document_id, revision_author, revision_live, revision_dead, revision_modified, revision_publish_status, revision_lock_status, revision_visible FROM cms_revisions WHERE revision_document_id = 117 AND revision_visible = 1 AND revision_live < NOW() AND revision_dead > NOW() AND revision_publish_status != 0 AND revision_deleted = 'N' ORDER BY revision_id DESC LIMIT 1
[4] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[5] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalKeywords' AND coc.choice_selected = '1'
[6] => SELECT template_id, template_content, template_title, template_description FROM cms_documents_templates WHERE template_id = 2 LIMIT 1
[7] => SELECT box_id, box_content FROM cms_revisions_boxes WHERE box_revision_id = 117 AND box_document_id = 117
[8] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'Basket'
[9] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductDisplay'
[10] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductSearch'
[11] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_id = 554 LIMIT 1
[12] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[13] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_parent_id = 554 AND category_visible = 'Y' ORDER BY category_title ASC
[14] => SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
A to Z Array
(
[PHP_FCGI_MAX_REQUESTS] => 500
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 0
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /d/117/Customise_my_own.html
[SCRIPT_URI] => http://www.mrflag.com/d/117/Customise_my_own.html
[HTTP_X_CC_ID] => ccc04-01
[HTTP_IF_MODIFIED_SINCE] => Fri, 02 Apr 2010 13:55:13 GMT
[HTTP_HOST] => www.mrflag.com
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_CONNECTION] => close
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_PRAGMA] => no-cache
[HTTP_COOKIE] => PHPSESSID=a54c85b7f9a137d5da147361cd3f7d44
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 67.23.46.233
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.114
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 10248
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=117
[REQUEST_URI] => /d/117/Customise_my_own.html
[SCRIPT_NAME] => /d/117/Customise_my_own.html
[PHP_SELF] => /d/117/Customise_my_own.html
[REQUEST_TIME] => 1283457735
[argv] => Array
(
[0] => doc=117
)
[argc] => 1
[db_cache] => Array
(
[SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #61
)
[q] => Array
(
[0] => SELECT document_id, document_title, document_meta_title, document_meta_description, document_meta_subject, document_folder, document_order, document_template, document_visible, document_protected FROM cms_documents WHERE document_id = 117 AND document_deleted = 'N' LIMIT 1
[1] => SELECT relationship_id, relationship_originator, relationship_recipient, relationship_type, relationship_medium, relationship_lang FROM cms_documents_relationships WHERE relationship_originator = '117'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 117 AND request_date = CURDATE()
[3] => SELECT revision_id, revision_document_id, revision_author, revision_live, revision_dead, revision_modified, revision_publish_status, revision_lock_status, revision_visible FROM cms_revisions WHERE revision_document_id = 117 AND revision_visible = 1 AND revision_live < NOW() AND revision_dead > NOW() AND revision_publish_status != 0 AND revision_deleted = 'N' ORDER BY revision_id DESC LIMIT 1
[4] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[5] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalKeywords' AND coc.choice_selected = '1'
[6] => SELECT template_id, template_content, template_title, template_description FROM cms_documents_templates WHERE template_id = 2 LIMIT 1
[7] => SELECT box_id, box_content FROM cms_revisions_boxes WHERE box_revision_id = 117 AND box_document_id = 117
[8] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'Basket'
[9] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductDisplay'
[10] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductSearch'
[11] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_id = 554 LIMIT 1
[12] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[13] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_parent_id = 554 AND category_visible = 'Y' ORDER BY category_title ASC
[14] => SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Z to A Array
(
[PHP_FCGI_MAX_REQUESTS] => 500
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 0
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /d/117/Customise_my_own.html
[SCRIPT_URI] => http://www.mrflag.com/d/117/Customise_my_own.html
[HTTP_X_CC_ID] => ccc04-01
[HTTP_IF_MODIFIED_SINCE] => Fri, 02 Apr 2010 13:55:13 GMT
[HTTP_HOST] => www.mrflag.com
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_CONNECTION] => close
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_PRAGMA] => no-cache
[HTTP_COOKIE] => PHPSESSID=a54c85b7f9a137d5da147361cd3f7d44
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 67.23.46.233
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.114
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 10248
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=117
[REQUEST_URI] => /d/117/Customise_my_own.html
[SCRIPT_NAME] => /d/117/Customise_my_own.html
[PHP_SELF] => /d/117/Customise_my_own.html
[REQUEST_TIME] => 1283457735
[argv] => Array
(
[0] => doc=117
)
[argc] => 1
[db_cache] => Array
(
[SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #61
)
[q] => Array
(
[0] => SELECT document_id, document_title, document_meta_title, document_meta_description, document_meta_subject, document_folder, document_order, document_template, document_visible, document_protected FROM cms_documents WHERE document_id = 117 AND document_deleted = 'N' LIMIT 1
[1] => SELECT relationship_id, relationship_originator, relationship_recipient, relationship_type, relationship_medium, relationship_lang FROM cms_documents_relationships WHERE relationship_originator = '117'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 117 AND request_date = CURDATE()
[3] => SELECT revision_id, revision_document_id, revision_author, revision_live, revision_dead, revision_modified, revision_publish_status, revision_lock_status, revision_visible FROM cms_revisions WHERE revision_document_id = 117 AND revision_visible = 1 AND revision_live < NOW() AND revision_dead > NOW() AND revision_publish_status != 0 AND revision_deleted = 'N' ORDER BY revision_id DESC LIMIT 1
[4] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[5] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalKeywords' AND coc.choice_selected = '1'
[6] => SELECT template_id, template_content, template_title, template_description FROM cms_documents_templates WHERE template_id = 2 LIMIT 1
[7] => SELECT box_id, box_content FROM cms_revisions_boxes WHERE box_revision_id = 117 AND box_document_id = 117
[8] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'Basket'
[9] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductDisplay'
[10] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductSearch'
[11] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_id = 554 LIMIT 1
[12] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[13] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_parent_id = 554 AND category_visible = 'Y' ORDER BY category_title ASC
[14] => SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price High to Low Array
(
[PHP_FCGI_MAX_REQUESTS] => 500
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 0
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /d/117/Customise_my_own.html
[SCRIPT_URI] => http://www.mrflag.com/d/117/Customise_my_own.html
[HTTP_X_CC_ID] => ccc04-01
[HTTP_IF_MODIFIED_SINCE] => Fri, 02 Apr 2010 13:55:13 GMT
[HTTP_HOST] => www.mrflag.com
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_CONNECTION] => close
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_PRAGMA] => no-cache
[HTTP_COOKIE] => PHPSESSID=a54c85b7f9a137d5da147361cd3f7d44
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 67.23.46.233
[SERVER_PORT] => 80
[REMOTE_ADDR] => 38.107.191.114
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 10248
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=117
[REQUEST_URI] => /d/117/Customise_my_own.html
[SCRIPT_NAME] => /d/117/Customise_my_own.html
[PHP_SELF] => /d/117/Customise_my_own.html
[REQUEST_TIME] => 1283457735
[argv] => Array
(
[0] => doc=117
)
[argc] => 1
[db_cache] => Array
(
[SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #61
)
[q] => Array
(
[0] => SELECT document_id, document_title, document_meta_title, document_meta_description, document_meta_subject, document_folder, document_order, document_template, document_visible, document_protected FROM cms_documents WHERE document_id = 117 AND document_deleted = 'N' LIMIT 1
[1] => SELECT relationship_id, relationship_originator, relationship_recipient, relationship_type, relationship_medium, relationship_lang FROM cms_documents_relationships WHERE relationship_originator = '117'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 117 AND request_date = CURDATE()
[3] => SELECT revision_id, revision_document_id, revision_author, revision_live, revision_dead, revision_modified, revision_publish_status, revision_lock_status, revision_visible FROM cms_revisions WHERE revision_document_id = 117 AND revision_visible = 1 AND revision_live < NOW() AND revision_dead > NOW() AND revision_publish_status != 0 AND revision_deleted = 'N' ORDER BY revision_id DESC LIMIT 1
[4] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[5] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalKeywords' AND coc.choice_selected = '1'
[6] => SELECT template_id, template_content, template_title, template_description FROM cms_documents_templates WHERE template_id = 2 LIMIT 1
[7] => SELECT box_id, box_content FROM cms_revisions_boxes WHERE box_revision_id = 117 AND box_document_id = 117
[8] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'Basket'
[9] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductDisplay'
[10] => SELECT revision_document_id FROM cms_revisions_boxes AS crb LEFT JOIN cms_revisions AS cr ON crb.box_revision_id = cr.revision_id WHERE TRIM(crb.box_content) = 'ProductSearch'
[11] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_id = 554 LIMIT 1
[12] => SELECT choice_value FROM cms_options AS co LEFT JOIN cms_options_choices AS coc ON co.option_id = coc.choice_option_id WHERE co.option_keyword = 'CMS::Documents::GlobalTitle' AND coc.choice_selected = '1'
[13] => SELECT category_id, category_parent_id, category_child_order, category_title, category_teaser, category_description, category_subject, category_image, category_visible FROM cms_categories WHERE category_deleted = 'N' AND category_parent_id = 554 AND category_visible = 'Y' ORDER BY category_title ASC
[14] => SELECT p.* FROM cms_products p INNER JOIN cms_categories_products cp ON p.product_id = cp.product_id INNER JOIN cms_products_variations pv ON p.product_id=pv.variation_product_id AND pv.variation_deleted='N' WHERE cp.category_id = 554 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price Low to High