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 = 108399
) 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
Helping your employees succeed through recognition and incentives.
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 = 108399
) 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 = 108399
) 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
Schwinn Grit Steerable Kids Bike, 12- Inch Wheels, Orange
The Schwinn Grit Boys' Bike with removable push handle comes with heavy-duty training wheels that provide the right support. This push pedal bike has wide street tires that enhance stability. Front and rear fenders as well as the fully enclosed chain guard ensure that your child is safe and clean. The push handle can be removed when he learns to ride alone. This kid's bike with training wheels comes with quick-release alloy saddle that can be adjusted as your child grows. Great news!
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 = 105800
) 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
