SELECT
ID,
post_date,
title,
p_w_meta_condensed.slug,
content,
meta_keys,
meta_values,
IFNULL(group_concat(tr.term_taxonomy_id separator ','), '') terms,
IFNULL(group_concat(t.name separator '|'), '') term_names
FROM
(
SELECT
id,
post_date,
post_title title,
post_name slug,
post_content content,
group_concat(meta_key separator '****') meta_keys,
group_concat(meta_value separator '****') meta_values
FROM (
SELECT *
FROM wp_posts p
JOIN wp_postmeta pm
ON p.id = pm.post_id
WHERE p.post_type = 'product'
AND p.post_status = 'publish'
AND pm.meta_key IN ('_product_attributes', '_price', '_regular_price', '_sale_price', '_stock_status', '_width', '_height', '_length', '_weight')
AND p.id = 115923
) AS p_w_meta GROUP BY id
) AS p_w_meta_condensed
LEFT JOIN wp_term_relationships tr
ON p_w_meta_condensed.ID = tr.object_id
LEFT JOIN wp_terms t
ON t.term_id = tr.term_taxonomy_id
GROUP BY ID
ORDER BY post_date, title
LIMIT 500
OFFSET 0
SELECT
ID,
post_date,
title,
p_w_meta_condensed.slug,
content,
meta_keys,
meta_values,
IFNULL(group_concat(tr.term_taxonomy_id separator ','), '') terms,
IFNULL(group_concat(t.name separator '|'), '') term_names
FROM
(
SELECT
id,
post_date,
post_title title,
post_name slug,
post_content content,
group_concat(meta_key separator '****') meta_keys,
group_concat(meta_value separator '****') meta_values
FROM (
SELECT *
FROM wp_posts p
JOIN wp_postmeta pm
ON p.id = pm.post_id
WHERE p.post_type = 'product'
AND p.post_status = 'publish'
AND pm.meta_key IN ('_product_attributes', '_price', '_regular_price', '_sale_price', '_stock_status', '_width', '_height', '_length', '_weight')
AND p.id = 115923
) AS p_w_meta GROUP BY id
) AS p_w_meta_condensed
LEFT JOIN wp_term_relationships tr
ON p_w_meta_condensed.ID = tr.object_id
LEFT JOIN wp_terms t
ON t.term_id = tr.term_taxonomy_id
GROUP BY ID
ORDER BY post_date, title
LIMIT 500
OFFSET 0
Ultra 21" 15-Amp Electric Snow Thrower
BRAND
SKU
SJ625E
RETAIL
$479.99
DETAILS
Responding to the need for an easy-to-use machine that could tackle heavier snowfall on mid-sized driveways and walkways, Snow Joe? developed the Snow Joe? Ultra SJ625E, a larger electric snow thrower that delivers the power of a gas machine with the convenience of an electric unit. Driven by a powerful 15-amp motor, the Snow Joe? Ultra moves up to 800 lbs of snow per minute. Its durable steel auger with 2 rubber blades cuts a path 21 inches wide by 12 inches deep with each pass. In addition to its exceptional plowing capacity, the Snow Joe? Ultra features an adjustable discharge chute that rotates a complete 180? to provide full control over the direction of the snow stream. The chute deflector can also be adjusted to control the height of the snow stream. Easy-glide all-terrain wheels make the Snow Joe? Ultra easy to turn and maneuver with each pass. The scraper blade at the base of the unit efficiently scrapes the snow clear to the ground without damaging your deck or pavement. Powered electrically, the Snow Joe? Ultra SJ625E is effortless to start and maintain. No gas, oil, or tune-ups are necessary. The unit is ETL-approved and carries a full two year warranty. For heavier snowfall on mid-sized driveways and walkways, the Snow Joe? Ultra SJ625E is your snow solution this winter.
