there was an error
  td.tid AS category_tid, AS category_name, 
  cat_alias.dst AS category_path, 
  CONCAT( 'taxonomy/term/', td.tid ) AS raw_category_path, 
  td2.tid AS subcategory_tid, AS subcategory_name, 
  subcat_alias.dst AS subcategory_path, 
  CONCAT( 'taxonomy/term/', td2.tid ) AS raw_subcategory_path, 
  n.title AS node_title, 
  n.created AS created_unix_time, 
  pd.published_at AS published_unix_time, 
  node_alias.dst AS node_path, 
  CONCAT( 'node/', tn.nid ) AS raw_node_path, 
  ca.field_front_is_popular_value AS node_is_popular, 
  ca.field_front_is_in_rotator_value AS is_in_front_rotator, 
  ffront.filepath AS front_rotator_image, 
  ca.field_front_rotator_text_value AS front_rotator_text, 
  ca.field_front_rotator_subtext_value AS front_rotator_subtext, 
  ca.field_category_is_popular_value AS category_node_is_popular, 
  ca.field_category_is_in_rotator_value AS is_in_category_rotator, 
  fcat.filepath AS category_rotator_image, 
  ca.field_category_rotator_text_value AS category_rotator_text, 
  ca.field_short_title_value AS node_short_title, 
  ca.field_short_description_value AS node_short_description, 
  CONCAT( '/images/', en1.image_name ) as thumb140x100, 
  CONCAT( '/images/', en2.image_name ) as thumb85x62, 
  CONCAT( '/images/', en3.image_name ) as thumb70x50 
FROM `term_hierarchy` th 
JOIN term_data td ON th.tid = td.tid AND parent = 0 
LEFT JOIN url_alias cat_alias ON cat_alias.src = CONCAT( 'taxonomy/term/', td.tid ) 
JOIN term_hierarchy th2 ON td.tid = th2.parent 
JOIN term_data td2 ON th2.tid = td2.tid  
LEFT JOIN url_alias subcat_alias ON subcat_alias.src = CONCAT( 'taxonomy/term/', td2.tid ) 
JOIN term_node tn ON tn.tid = td2.tid 
JOIN node n ON n.nid = tn.nid AND n.type = 'article' AND status = 1 
LEFT JOIN publication_date AS pd ON n.nid = pd.nid 
LEFT JOIN url_alias node_alias ON node_alias.src = CONCAT( 'node/', tn.nid ) 
JOIN content_type_article ca ON n.nid = ca.nid 
LEFT JOIN eco_node_image en1 ON en1.nid = n.nid AND en1.image_type = 'thumb140x100' 
LEFT JOIN eco_node_image en2 ON en2.nid = n.nid AND en2.image_type = 'thumb85x62' 
LEFT JOIN eco_node_image en3 ON en3.nid = n.nid AND en3.image_type = 'thumb70x50' 
LEFT JOIN files ffront ON ffront.fid = ca.field_front_rotator_image_fid 
LEFT JOIN files fcat ON fcat.fid = ca.field_category_rotator_image_fid 
WHERE td.vid = 1 
AND != 'Blogs' 
ORDER BY td.weight, td.tid, td2.weight, td2.tid, tn.weight_in_tid, tn.nid 
Stop Junk Mail

Stop Junk Mail

Steps to Stop Junk Mail Delivery

If you’ve ever felt aggravated over the unbelievable number of pieces of mail coming to your house daily, then you’re ready to stop the junk mail madness. And if you’re not quite yet sure whether you should bother, check out these junk mail stats:

  • Junk mail in the US is almost epidemic, with over 1 billion pieces of mail sent from companies and nonprofits every year.[1]
  • Developed countries consume 87% of all the writing and printing paper used worldwide.[2]
  • The paper industry consumes the largest portion of forest resources, which are most often taken from ecologically sensitive regions like the Boreal Forests in Canada and plantations in Indonesia.[3]
  • Most Britons receive 8 pieces of junk mail a week (400 a year),[4] while Americans receive more than double that.[5]


Steps to stop junk mail 

Get control of your mailbox by using these ideas for stopping junk mail from coming to your home. Your letterbox will thank you for the weight it loses and the planet will be thankful for protecting its forests.

  • “No junk mail” sign: Sometimes it’s the simplest things that solves the problem. You could try putting a “No Junk Mail” sign on the inside or outside of your letterbox to discourage the mailman from leaving unwanted junk.
  • Get your name on the “do not mail” list: These industry associations often maintain “do not mail” lists. By signing up for a direct marketing association’s opt out program, you’ll be cutting the junk mail off at the source since they’ll no longer be able to trade or sell your information. You can even get your name on the “Do Not Call Registry” to stop telemarketing calls, too!
  • Register with a junk mail management organization: By signing up with one of these organizations, you’ll be having someone else reduce the aggravation of junk mail for you. By paying an annual fee, these organizations handle the removal of your name from common registry and exchange lists:

Note that some countries have stricter direct mail policies protecting consumers, the number of mail reduction services are often limited.

  • Contact companies directly: Advocate for yourself by talking directly to companies like Victoria’s Secret and Sears and ask them to remove you from their mailing lists. Do the same with nonprofit organizations and any other solicitors you’d rather not hear from every week. And don’t forget to call credit card companies and tell them they do not have permission to sell or trade your information to other organizations. Most direct mail comes with a contact phone number and/or email you can use for this purpose. Three big offenders can be reached at the following numbers:
    • America Online Discs - 1-800-827-6364
    • Clearinghouse Sweepstakes - 1-800-645-9242
    • Val-Pak Coupons - 1-800-676-6878
  • Don’t fill out warranty cards: These are primarily used to collect your personal information for the purposes of selling or trading it later. So unless they’re required for warranty purposes (most are not), do not mail them in.

If you want to further reduce your paper mail then check out our Reduce Mail article. 



1  Junk Mail Campaign. (n.d.). Retrieved June 28, 2010, from ForestEthics:

2 Global and U.S. Paper Production and Consumption Statistics. (n.d.). Retrieved June 28, 2010, from Environmental Paper Network:

3  (Global and U.S. Paper Production and Consumption Statistics)  

4 The size of the problem. (n.d.). Retrieved June 28, 2010, from Green Letterbox:

5  (Junk Mail Campaign)

Stay Connected.
You've been added to our mailing list.
Thank you for signing up!
Like ecolife on Facebook & Google, and join us in the Green movement!