Fabulous low-cost flags printed onto high quality lightweight polyester in bold, clear colours. Great for indoor/outdoor/sporting use. Finished as standard with US-style metal eyelets/grommets.
Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[REDIRECT_SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_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] => 23.22.76.170
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 36886
[REDIRECT_QUERY_STRING] => doc=11&cid=2758
[REDIRECT_URL] => /c/2758/Budget_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2758
[REQUEST_URI] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_NAME] => /c/2758/Budget_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2758/Budget_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2758/Budget_Printed_Flags.html
[REQUEST_TIME] => 1369305993
[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 = 2758 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 = 2758 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 = 2758 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 = 2758 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] => UZ3zicCosIUAABzsVjEAAAAD
[REDIRECT_SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_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] => 23.22.76.170
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 36886
[REDIRECT_QUERY_STRING] => doc=11&cid=2758
[REDIRECT_URL] => /c/2758/Budget_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2758
[REQUEST_URI] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_NAME] => /c/2758/Budget_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2758/Budget_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2758/Budget_Printed_Flags.html
[REQUEST_TIME] => 1369305993
[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 = 2758 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 = 2758 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 = 2758 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 = 2758 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] => UZ3zicCosIUAABzsVjEAAAAD
[REDIRECT_SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_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] => 23.22.76.170
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 36886
[REDIRECT_QUERY_STRING] => doc=11&cid=2758
[REDIRECT_URL] => /c/2758/Budget_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2758
[REQUEST_URI] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_NAME] => /c/2758/Budget_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2758/Budget_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2758/Budget_Printed_Flags.html
[REQUEST_TIME] => 1369305993
[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 = 2758 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 = 2758 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 = 2758 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 = 2758 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] => UZ3zicCosIUAABzsVjEAAAAD
[REDIRECT_SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_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] => 23.22.76.170
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 36886
[REDIRECT_QUERY_STRING] => doc=11&cid=2758
[REDIRECT_URL] => /c/2758/Budget_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2758
[REQUEST_URI] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_NAME] => /c/2758/Budget_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2758/Budget_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2758/Budget_Printed_Flags.html
[REQUEST_TIME] => 1369305993
[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 = 2758 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 = 2758 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 = 2758 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 = 2758 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] => UZ3zicCosIUAABzsVjEAAAAD
[REDIRECT_SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_Printed_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZ3zicCosIUAABzsVjEAAAAD
[SCRIPT_URL] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2758/Budget_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] => 23.22.76.170
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 36886
[REDIRECT_QUERY_STRING] => doc=11&cid=2758
[REDIRECT_URL] => /c/2758/Budget_Printed_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2758
[REQUEST_URI] => /c/2758/Budget_Printed_Flags.html
[SCRIPT_NAME] => /c/2758/Budget_Printed_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2758/Budget_Printed_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2758/Budget_Printed_Flags.html
[REQUEST_TIME] => 1369305993
[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 = 2758 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 = 2758 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 = 2758 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 = 2758 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price Low to High
England, Bedfordshire (Budget)
Printed economy flag. Eyelets/grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Berkshire (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Buckinghamshire (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Cambridgeshire (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Cheshire (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Cornwall (St Piran) (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £2.99 Now: £2.69 Save: £0.30
England, Cumbria (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Derbyshire (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Devon (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £2.99 Now: £2.69 Save: £0.30
England, Dorset (Budget)
Printed economy flag. Eyelets/grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Dorset Lions (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Durham County (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, East Anglia (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, East Sussex (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Essex (Budget)
Printed economy flag. Eyelets/Grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40
England, Gloucestershire, New (Budget)
Printed economy flag. Eyelets/grommets
More Info »
Prices From: £3.98 Now: £3.58 Save: £0.40