MrFlag Brand Traditional Flags are manufactured using a combination of traditional sewing using a woven polyester fabric designed specifically for the flag industry, and the appliqué of printed knitted polyester for more complicated elements.
Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[REDIRECT_UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[REDIRECT_SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_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] => 107.22.156.205
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 33482
[REDIRECT_QUERY_STRING] => doc=11&cid=2757
[REDIRECT_URL] => /c/2757/Traditional_Sewn_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2757
[REQUEST_URI] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_NAME] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2757/Traditional_Sewn_Flags.html
[REQUEST_TIME] => 1369183822
[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 = 2757 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 = 2757 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 = 2757 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 = 2757 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] => UZwWTsCosIUAAGoOoSQAAAAM
[REDIRECT_SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_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] => 107.22.156.205
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 33482
[REDIRECT_QUERY_STRING] => doc=11&cid=2757
[REDIRECT_URL] => /c/2757/Traditional_Sewn_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2757
[REQUEST_URI] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_NAME] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2757/Traditional_Sewn_Flags.html
[REQUEST_TIME] => 1369183822
[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 = 2757 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 = 2757 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 = 2757 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 = 2757 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] => UZwWTsCosIUAAGoOoSQAAAAM
[REDIRECT_SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_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] => 107.22.156.205
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 33482
[REDIRECT_QUERY_STRING] => doc=11&cid=2757
[REDIRECT_URL] => /c/2757/Traditional_Sewn_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2757
[REQUEST_URI] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_NAME] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2757/Traditional_Sewn_Flags.html
[REQUEST_TIME] => 1369183822
[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 = 2757 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 = 2757 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 = 2757 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 = 2757 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] => UZwWTsCosIUAAGoOoSQAAAAM
[REDIRECT_SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_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] => 107.22.156.205
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 33482
[REDIRECT_QUERY_STRING] => doc=11&cid=2757
[REDIRECT_URL] => /c/2757/Traditional_Sewn_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2757
[REQUEST_URI] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_NAME] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2757/Traditional_Sewn_Flags.html
[REQUEST_TIME] => 1369183822
[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 = 2757 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 = 2757 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 = 2757 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 = 2757 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] => UZwWTsCosIUAAGoOoSQAAAAM
[REDIRECT_SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[REDIRECT_SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_Flags.html
[REDIRECT_HANDLER] => php5-fcgi
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => UZwWTsCosIUAAGoOoSQAAAAM
[SCRIPT_URL] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/2757/Traditional_Sewn_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] => 107.22.156.205
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 33482
[REDIRECT_QUERY_STRING] => doc=11&cid=2757
[REDIRECT_URL] => /c/2757/Traditional_Sewn_Flags.html
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.0
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=2757
[REQUEST_URI] => /c/2757/Traditional_Sewn_Flags.html
[SCRIPT_NAME] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_SCRIPT_FILENAME] => /usr/lib/cgi-bin/php5-fcgi
[ORIG_PATH_INFO] => /c/2757/Traditional_Sewn_Flags.html
[ORIG_PATH_TRANSLATED] => /var/www/mrflag.com/www/index.php
[ORIG_SCRIPT_NAME] => /php5-fcgi
[PHP_SELF] => /c/2757/Traditional_Sewn_Flags.html
[REQUEST_TIME] => 1369183822
[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 = 2757 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 = 2757 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 = 2757 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 = 2757 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price Low to High
England, Bedfordshire (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £130.69 £117.62 £13.07
England, Berkshire (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £88.34 £79.51 £8.83
England, City of London (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £61.72 £55.55 £6.17
England, Cornwall (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £11.64 £10.48 £1.16
England, Cumberland (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £9.80 £8.82 £0.98
England, Derbyshire (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £49.49 £44.54 £4.95
England, Devon (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £13.10 £11.79 £1.31
England, Dorset (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £13.10 £11.79 £1.31
England, Durham County (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £130.69 £117.62 £13.07
England, East Anglia (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £88.34 £79.51 £8.83
England, Essex (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £56.16 £50.54 £5.62
England, Hertfordshire County (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £88.34 £79.51 £8.83
England, Kent (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £107.46 £96.71 £10.75
England, Lancashire (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £88.34 £79.51 £8.83
England, Lincolnshire (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £35.50 £31.95 £3.55
England, Middlesex (Traditional)
Traditional quality flag fitted with rope & toggle.
More Info »
Prices From: £35.28 £31.75 £3.53
England, Bedfordshire (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £130.69England, Berkshire (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £88.34England, City of London (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £61.72England, Cornwall (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £11.64England, Cumberland (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £9.80England, Derbyshire (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £49.49England, Devon (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £13.10England, Dorset (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £13.10England, Durham County (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £130.69England, East Anglia (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £88.34England, Essex (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £56.16England, Hertfordshire County (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £88.34England, Kent (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £107.46England, Lancashire (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £88.34England, Lincolnshire (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £35.50England, Middlesex (Traditional) Traditional quality flag fitted with rope & toggle.
More Info »Prices From: £35.28
