IN子句中缺少文本或数据

c.category_id IN ('test1','teswt2')

代替text1和test2，您必须输入自己的文本或数据

SELECT 
    g.*
    , GROUP_CONCAT(DISTINCT c.category_id) as `categories`
    , GROUP_CONCAT(DISTINCT p.product_id) as `products` 
FROM wpav_za_groups as g 
    LEFT JOIN wpav_za_categories_to_groups as c ON c.group_id = g.id 
    LEFT JOIN wpav_za_products_to_groups as p ON p.group_id = g.id 
WHERE 
    c.category_id IN ('test1','teswt2') 
    OR p.product_id = 30582 
    OR g.apply_to = 'all' 
GROUP BY g.id 
ORDER BY g.priority ASC

// Assuming you have an array of category IDs ($categoryIDs) and a product ID 
($productID)
$categoryIDs = array(1, 2, 3); // Replace with your actual category IDs
$productID = 30582; // Replace with your actual product ID

// Prepare the category IDs for the SQL query
$categoryIDsString = implode(', ', $categoryIDs);

// Perform the database query with the modified SQL query
$query = "SELECT 
g.*,
GROUP_CONCAT(DISTINCT c.category_id) as `categories`,
GROUP_CONCAT(DISTINCT p.product_id) as `products`
FROM wpav_za_groups as g
LEFT JOIN wpav_za_categories_to_groups as c ON c.group_id = g.id
LEFT JOIN wpav_za_products_to_groups as p ON p.group_id = g.id
WHERE
c.category_id IN ($categoryIDsString)
OR p.product_id = $productID
OR g.apply_to = 'all'
GROUP BY g.id
ORDER BY g.priority ASC";

// Execute the query and handle the results
$result = $wpdb->get_results($query);