Back
Tiberius Oval Meeting Table
PRODUCT SKU: OFFI-WP-574367
` 0
Price excludes GST. GST is added during checkout.
Quantity
- +WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8]
SELECT
tm.meta_value AS subgroup_id,
REPLACE(REPLACE(tm.meta_key, 'collection_fields_', ''), '_sub_group_select_sub_group', '') AS position
FROM della_ws_termmeta tm
JOIN della_ws_term_taxonomy tt ON tt.term_id = tm.term_id
WHERE tm.meta_key LIKE '%select_sub_group%'
AND tt.taxonomy = 'master-collection'
AND tt.term_id =
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN della_ws_postmeta pm2
ON p.ID = pm2.post_id AND pm2.meta_key = 'hi' at line 16]
SELECT
p.ID AS product_id,
p.post_title,
pm.meta_value AS master_collection_id,
pm2.meta_value AS hide_product,
img_meta.meta_value AS thumbnail_id,
img_post.guid AS image_url,
pm3.meta_value AS size,
pm4.meta_value as price
FROM della_ws_posts p
LEFT JOIN della_ws_postmeta pm
ON p.ID = pm.post_id AND pm.meta_key = 'master_collection' AND pm.meta_value =
LEFT JOIN della_ws_postmeta pm2
ON p.ID = pm2.post_id AND pm2.meta_key = 'hide_product'
LEFT JOIN della_ws_postmeta img_meta
ON p.ID = img_meta.post_id AND img_meta.meta_key = '_thumbnail_id'
LEFT JOIN della_ws_posts img_post
ON img_post.ID = img_meta.meta_value AND img_post.post_type = 'attachment'
left join della_ws_postmeta pm3
on pm3.post_id = p.ID and pm3.meta_key = 'standard_collection_size'
left join della_ws_termmeta pm4
on pm3.meta_value = pm4.term_id and pm4.meta_key = 'product_base_price_for_size'
WHERE
p.post_type = 'product' AND
p.post_status = 'publish' AND
pm2.meta_value != '1' and
pm3.meta_value is NOT NULL
LIMIT 4;
