"product_sku","product_name","manufacturer_name","product_price","related_products","category_path","product_parent_sku","published","product_in_stock"
Error: 1054 Unknown column 'jos_virtuemart_product_customfields.custom_value' in 'on clause' SQL=SELECT `jos_virtuemart_products`.`product_sku`
FROM `jos_virtuemart_product_customfields`
LEFT JOIN `jos_virtuemart_customs` ON `jos_virtuemart_customs`.`virtuemart_custom_id` = `jos_virtuemart_product_customfields`.`virtuemart_custom_id`
LEFT JOIN `jos_virtuemart_products` ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_customfields`.`custom_value`
WHERE `jos_virtuemart_customs`.`field_type` = 'R' AND `jos_virtuemart_product_customfields`.`virtuemart_product_id` = '1'
GROUP BY `jos_virtuemart_products`.`product_sku`
Error
An error has occurred.
1054 Unknown column 'jos_virtuemart_product_customfields.custom_value' in 'on clause' SQL=SELECT `jos_virtuemart_products`.`product_sku`
FROM `jos_virtuemart_product_customfields`
LEFT JOIN `jos_virtuemart_customs` ON `jos_virtuemart_customs`.`virtuemart_custom_id` = `jos_virtuemart_product_customfields`.`virtuemart_custom_id`
LEFT JOIN `jos_virtuemart_products` ON `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_customfields`.`custom_value`
WHERE `jos_virtuemart_customs`.`field_type` = 'R' AND `jos_virtuemart_product_customfields`.`virtuemart_product_id` = '1'
GROUP BY `jos_virtuemart_products`.`product_sku`
