Выборка из двух таблиц mysql

sql запрос для выборки адресов товаров в наличии woocommerce.

SELECT CONCAT("https://site.name",p.name) as 'PRODUCT URL'
    FROM wp_posts as p
    INNER JOIN wp_postmeta as pm ON p.ID = pm.post_id
    WHERE p.post_type LIKE 'product'
    AND p.post_status LIKE 'publish'
    AND p.post_parent = '0'
    AND pm.meta_key LIKE '_stock_status'
    AND pm.meta_value LIKE 'instock'

SELECT CONCAT("https://site.name",p.name) as 'PRODUCT URL'

FROM wp_posts as p

INNER JOIN wp_postmeta as pm ON p.ID = pm.post_id

WHERE p.post_type LIKE 'product'

AND p.post_status LIKE 'publish'

AND p.post_parent = '0'

AND pm.meta_key LIKE '_stock_status'

AND pm.meta_value LIKE 'instock'

Добавить комментарий Отменить ответ