MrFlag Brand Professional Flags are the most versatile and best value flags on the market in the UK today. Combining top of the range materials and optimum flying weights, these flags last as well as Traditional flags but fly much better at lower windspeeds. (NOTE: heavier Traditional flags appear to last longer because they spend less time flying).
Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[REDIRECT_SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[HTTP_HOST] => www.mrflag.com
[HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
[HTTP_USER_AGENT] => CCBot/2.0
[HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 176.58.120.165
[SERVER_PORT] => 80
[REMOTE_ADDR] => 50.17.109.248
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 52799
[REDIRECT_QUERY_STRING] => doc=11&cid=2759
[REDIRECT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2759
[REQUEST_URI] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_NAME] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2759/Professional_Quality_Printed_Flags.html
[REQUEST_TIME] => 1369126694
[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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #60
)
[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 = 11 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 = '11'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 11 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 = 11 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 = 11 AND box_document_id = 11
[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 = 2759 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 = 2759 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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Sort By... Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[REDIRECT_SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[HTTP_HOST] => www.mrflag.com
[HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
[HTTP_USER_AGENT] => CCBot/2.0
[HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 176.58.120.165
[SERVER_PORT] => 80
[REMOTE_ADDR] => 50.17.109.248
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 52799
[REDIRECT_QUERY_STRING] => doc=11&cid=2759
[REDIRECT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2759
[REQUEST_URI] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_NAME] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2759/Professional_Quality_Printed_Flags.html
[REQUEST_TIME] => 1369126694
[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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #60
)
[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 = 11 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 = '11'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 11 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 = 11 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 = 11 AND box_document_id = 11
[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 = 2759 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 = 2759 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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
A to Z Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[REDIRECT_SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[HTTP_HOST] => www.mrflag.com
[HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
[HTTP_USER_AGENT] => CCBot/2.0
[HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 176.58.120.165
[SERVER_PORT] => 80
[REMOTE_ADDR] => 50.17.109.248
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 52799
[REDIRECT_QUERY_STRING] => doc=11&cid=2759
[REDIRECT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2759
[REQUEST_URI] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_NAME] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2759/Professional_Quality_Printed_Flags.html
[REQUEST_TIME] => 1369126694
[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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #60
)
[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 = 11 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 = '11'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 11 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 = 11 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 = 11 AND box_document_id = 11
[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 = 2759 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 = 2759 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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Z to A Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[REDIRECT_SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[HTTP_HOST] => www.mrflag.com
[HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
[HTTP_USER_AGENT] => CCBot/2.0
[HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 176.58.120.165
[SERVER_PORT] => 80
[REMOTE_ADDR] => 50.17.109.248
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 52799
[REDIRECT_QUERY_STRING] => doc=11&cid=2759
[REDIRECT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2759
[REQUEST_URI] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_NAME] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2759/Professional_Quality_Printed_Flags.html
[REQUEST_TIME] => 1369126694
[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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #60
)
[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 = 11 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 = '11'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 11 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 = 11 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 = 11 AND box_document_id = 11
[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 = 2759 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 = 2759 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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price High to Low Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[REDIRECT_SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZs3JsCosIUAACMXUVgAAAAB
[SCRIPT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2759/Professional_Quality_Printed_Flags.html
[HTTP_HOST] => www.mrflag.com
[HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
[HTTP_USER_AGENT] => CCBot/2.0
[HTTP_ACCEPT_LANGUAGE] => en-us,en-gb,en;q=0.7,*;q=0.3
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => www.mrflag.com
[SERVER_ADDR] => 176.58.120.165
[SERVER_PORT] => 80
[REMOTE_ADDR] => 50.17.109.248
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 52799
[REDIRECT_QUERY_STRING] => doc=11&cid=2759
[REDIRECT_URL] => /c/2759/Professional_Quality_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2759
[REQUEST_URI] => /c/2759/Professional_Quality_Printed_Flags.html
[SCRIPT_NAME] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2759/Professional_Quality_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2759/Professional_Quality_Printed_Flags.html
[REQUEST_TIME] => 1369126694
[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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #60
)
[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 = 11 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 = '11'
[2] => UPDATE cms_documents_requests SET request_count = request_count + 1 WHERE request_document = 11 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 = 11 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 = 11 AND box_document_id = 11
[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 = 2759 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 = 2759 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 = 2759 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price Low to High
England, Bedfordshire (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Berkshire (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Black Country (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Buckinghamshire (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Cornwall (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Derbyshire (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Devon (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Durham (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, East Anglia (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Huntingdonshire (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
Preston and South Ribble (Professional)
Professional quality printed flag.
More Info »
Prices From: £15.00 £13.50 £1.50
England, Bedfordshire (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Berkshire (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Black Country (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Buckinghamshire (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Cornwall (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Derbyshire (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Devon (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Durham (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, East Anglia (Professional) Professional quality printed flag.
More Info »Prices From: £15.00England, Huntingdonshire (Professional) Professional quality printed flag.
More Info »Prices From: £15.00Preston and South Ribble (Professional) Professional quality printed flag.
More Info »Prices From: £15.00
