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 = 125818
) 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 = 125818
) 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 = 125818
) 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
15W Two-way GMSR radio broadcasts up to 3 times the range of other GMSR radios. External magnetic mount antenna for extended range. 8 Repeater channels. 15 Hi power channels. 142 Privacy codes. NOAA weather radio. Silent operation. Channel scan. Programmable squelch. Keypad lock. Monitor mode. Keystroke tones. Backlit display. Compatible with all Midland GMRS radios. Dimensions with bracket: 5"D x 5.25"W x 1"H. Max range of 50 miles with no obstruction. Ideal range 10-15 miles with partial obstructions 5-10 with major obstructions.
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 = 129761
) 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 = 129517
) 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 = 127445
) 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
