Warning: include(/home/avantgar/public_html/plugins/editors/jce/help.php) [function.include]: failed to open stream: No such file or directory in /home/avantgar/public_html/index.php on line 3

Warning: include() [function.include]: Failed opening '/home/avantgar/public_html/plugins/editors/jce/help.php' for inclusion (include_path='.:/usr/lib/php') in /home/avantgar/public_html/index.php on line 3

Warning: include(/home/avantgar/public_html/ag/modules/mod_breadcrumbs/css.php) [function.include]: failed to open stream: No such file or directory in /home/avantgar/public_html/libraries/import.php on line 5

Warning: include() [function.include]: Failed opening '/home/avantgar/public_html/ag/modules/mod_breadcrumbs/css.php' for inclusion (include_path='.:/usr/lib/php') in /home/avantgar/public_html/libraries/import.php on line 5
Avant Gardener
Home

aglogo

Publisher and Editor-in-Chief, Derek Fell, Cedaridge Farm, 53 Iron Bridge Road, Pipersville, PA 18947
and 760 Cardium Street, Sanibel, FL 33957

subscribe

Water garden at Cedaridge Farm North serves as a plunge pool

SUBSCRIBE TODAY!

America's Premier Award-Winning Horticultural Newsletter

Awards for literary excellence from the Massachusetts Horticultural Society, the Garden Club of America, Bedding Plants Inc, and twice from the Garden Writers Association

 

 


 

 

USA and Foreign Subscriptions

The Avant Gardener 

53 Iron Bridge Road

Pipersville, PA 18947

Error
  • Can't create/write to file '/tmp/#sql_1561_1.MYI' (Errcode: 122) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM ga3sf_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ga3sf_content AS a LEFT JOIN ga3sf_categories AS c ON c.id = a.catid LEFT JOIN ga3sf_users AS ua ON ua.id = a.created_by LEFT JOIN ga3sf_users AS uam ON uam.id = a.modified_by LEFT JOIN ga3sf_categories as parent ON parent.id = c.parent_id LEFT JOIN ga3sf_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ga3sf_categories AS cat JOIN ga3sf_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN ga3sf_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-18 13:10:50') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-18 13:10:50') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 6 Can't create/write to file '/tmp/#sql_1561_1.MYI' (Errcode: 122) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM ga3sf_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ga3sf_content AS a LEFT JOIN ga3sf_categories AS c ON c.id = a.catid LEFT JOIN ga3sf_users AS ua ON ua.id = a.created_by LEFT JOIN ga3sf_users AS uam ON uam.id = a.modified_by LEFT JOIN ga3sf_categories as parent ON parent.id = c.parent_id LEFT JOIN ga3sf_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ga3sf_categories AS cat JOIN ga3sf_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN ga3sf_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-18 13:10:50') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-18 13:10:50') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC

How To Subscribe

Check out the August 2012 issue of Avant Gardener FREE, and decide whether this information will be useful to you. If you like it and wish to receive your monthly copy of Avant Gardener online the annual subscription is $28.00, or two years for $48.00 (save $8.00), or three years for $68.00 (save $16.00).

Click here to view your FREE ISSUE, or click here to SUBSCRIBE NOW!

USA and Foreign Subscriptions

The Avant Gardener

53 Iron Bridge Road

Pipersville, PA 18947