This thread is resolved. Here is a description of the problem and solution.
How to display, using sql query, the products that have custom attributes?
The custom attribute information are stored on the *_postmeta table. Thus, we can write the sql query like this:
SELECT t1.ID, t1.post_title, t2.meta_key, t2.meta_value FROM wp_posts AS t1 INNER JOIN wp_postmeta AS t2 ON t2.post_id = t1.ID WHERE t2.meta_key = '_product_attributes' and t2.meta_value LIKE '%|%'
This will show all products that have custom attributes and are divided by the pipe "|" (more than 1 attribute ).
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.