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 = 98763
) 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 = 98763
) 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 = 98763
) 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
Jacket H2O 4 Waterproof Bluetooth Speaker Royal Blue
This floating rugged design speaker is perfect for use on land or in the water. Easily pairs with Bluetooth enabled devices. IP67 Rated: Water snow dust and shockproof design. 100 ft Wireless range. Up to 10 hours of battery life. Access voice assistant with your smart devices. Connect two speakers together with true wireless pairing. Dual 1.5" neodymium drivers. Two 40mm passive radiators. Output power: 6W. Includes Durable carabineer strap.
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
