15x7.5cm / 6x3in printed 'art-silk' table flags. Available in most countries flags. Allow 7 days for delivery of this product.
Choose from:
WORLD: Abu Dhabi, Afghanistan, Albania, Algeria, American Samoa, Anguilla, Argentina, Aruba, Angola, Antigua and Barbusse, Armenia, Azerbaijan, Australia, Bahrain, Bahamas, Bangladesh, Barbados, Basque, Belarus, Benin, Bermuda, Bhutan, Botswana, Brazil, Brittany, Bulgaria, Burundi, Brunei, Cambodia, Cameroon, Canada, Catalonia, Chad, Chile, China, Columbia, Comoros, Cook Islands, Congo (Dem. Rep.), Congo, Costa Rica, Croatia, Cuba, Djibouti, Dominica, Dominican Rep., Dubai, Ecuador, Egypt, Ethiopia, Fiji, Faroe, Gabon, Galicia, Gambia, Georgia, Gibraltar, Grenada, Guan, Guatemala, Guinea-Bissau, Guinea, Guyana, Haiti, Honduras, Hong Kong, Iceland, India, Iran, Indonesia, Iraq, Israel, Ivory Coast, Jamaica, Japan, Jordan, Kazakhstan, Kenya, North Korea, South Korea, Kuwait, Kyrgyzstan, Lesotho, Laos, Lebanon, Libya, Liberia, Lichtenstein, Malaysia, Macedonia, Madagascar, Madeira, Malawi, Maldives, Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Morocco, Montserrat, Mozambique, Namibia, Nepal, New Zealand, Nicaragua, Niger, Nigeria, Norfolk Island, Norway, Orkney, Oman, Pakistan, Palestine, Panama, Papua, Paraguay, Peru, Philippines, Puerto Rico, Romania, Rwanda, Russia, Saudi Arabia, St. Kitts, St. Lucia, Saw Marino, Solomon Islands, Western Samoa, Senegal, Seychelles, Sierra Leone, Shetland, Singapore, Somalia, Somaliland, Sri Lanka, Sudan, Surinam, Swaziland, Switzerland, Syria, Tanzania, Taiwan, Texas, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkmenistan, Turkey, Tuvalu, USA, USA Confederate, Uganda, Ukraine, UAE, United Nations, Upper Volta, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, N. Vietnam, Virgin Islands, South Yemen, Yemen (Arab Rep), Yugoslavia, Zimbabwe, Zambia
MISCELLANIOUS: Jolly Roger, Chequered, BSI Registered, Charter Mark, Red Cross, NATO, Burma Star, Royal British Legion, British Airways
EEC: Austria, Belgium, Cyprus, Czech Rep, Denmark, Eire, Estonia, Finland, France, Germany, Greece, Hungary, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Slovakia, Slovenia, Sweden, Spain, EEC-flag
UNITED KINGDOM: Welsh Dragon, Isle of Man, RAF Ensign, Red Ensign, Blue Ensign, White Ensign, Queens Award, Cornwall (St Pirran), Wales St David, St George, Union, St Patrick, St Andrew
Array
(
[PHP_FCGI_MAX_REQUESTS] => 5000
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 1
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /c/606/Table_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/606/Table_Flags.html
[HTTP_X_CC_ID] => ccc03-02
[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=6246d19470ee454a8c5b0343a244e187
[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.116
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 39881
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=606
[REQUEST_URI] => /c/606/Table_Flags.html
[SCRIPT_NAME] => /c/606/Table_Flags.html
[PHP_SELF] => /c/606/Table_Flags.html
[REQUEST_TIME] => 1268401830
[argv] => Array
(
[0] => doc=11&cid=606
)
[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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #59
)
[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 = 606 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 = 606 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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Sort By... Array
(
[PHP_FCGI_MAX_REQUESTS] => 5000
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 1
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /c/606/Table_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/606/Table_Flags.html
[HTTP_X_CC_ID] => ccc03-02
[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=6246d19470ee454a8c5b0343a244e187
[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.116
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 39881
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=606
[REQUEST_URI] => /c/606/Table_Flags.html
[SCRIPT_NAME] => /c/606/Table_Flags.html
[PHP_SELF] => /c/606/Table_Flags.html
[REQUEST_TIME] => 1268401830
[argv] => Array
(
[0] => doc=11&cid=606
)
[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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #59
)
[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 = 606 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 = 606 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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
A to Z Array
(
[PHP_FCGI_MAX_REQUESTS] => 5000
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 1
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /c/606/Table_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/606/Table_Flags.html
[HTTP_X_CC_ID] => ccc03-02
[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=6246d19470ee454a8c5b0343a244e187
[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.116
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 39881
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=606
[REQUEST_URI] => /c/606/Table_Flags.html
[SCRIPT_NAME] => /c/606/Table_Flags.html
[PHP_SELF] => /c/606/Table_Flags.html
[REQUEST_TIME] => 1268401830
[argv] => Array
(
[0] => doc=11&cid=606
)
[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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #59
)
[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 = 606 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 = 606 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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Z to A Array
(
[PHP_FCGI_MAX_REQUESTS] => 5000
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 1
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /c/606/Table_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/606/Table_Flags.html
[HTTP_X_CC_ID] => ccc03-02
[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=6246d19470ee454a8c5b0343a244e187
[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.116
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 39881
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=606
[REQUEST_URI] => /c/606/Table_Flags.html
[SCRIPT_NAME] => /c/606/Table_Flags.html
[PHP_SELF] => /c/606/Table_Flags.html
[REQUEST_TIME] => 1268401830
[argv] => Array
(
[0] => doc=11&cid=606
)
[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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #59
)
[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 = 606 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 = 606 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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price High to Low Array
(
[PHP_FCGI_MAX_REQUESTS] => 5000
[PHPRC] => /etc/php5/cgi
[PHP_FCGI_CHILDREN] => 1
[PWD] => /var/www/fcgi-bin.d/mrflag.com
[FCGI_ROLE] => RESPONDER
[SCRIPT_URL] => /c/606/Table_Flags.html
[SCRIPT_URI] => http://www.mrflag.com/c/606/Table_Flags.html
[HTTP_X_CC_ID] => ccc03-02
[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=6246d19470ee454a8c5b0343a244e187
[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.116
[DOCUMENT_ROOT] => /var/www/mrflag.com/www/
[SERVER_ADMIN] => webmaster@mrflag.com
[SCRIPT_FILENAME] => /var/www/mrflag.com/www/index.php
[REMOTE_PORT] => 39881
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => doc=11&cid=606
[REQUEST_URI] => /c/606/Table_Flags.html
[SCRIPT_NAME] => /c/606/Table_Flags.html
[PHP_SELF] => /c/606/Table_Flags.html
[REQUEST_TIME] => 1268401830
[argv] => Array
(
[0] => doc=11&cid=606
)
[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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC] => Resource id #59
)
[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 = 606 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 = 606 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 = 606 AND product_visible = 'Y' GROUP BY p.product_id ORDER BY p.product_title ASC
)
)
Price Low to High