1060. Query Error 1060: Duplicate column name 'id'
Query: SELECT COUNT(*) FROM (SELECT p.*,p.id,SUM(si.weight) AS weight,COUNT(*) AS weight_count,(p.count > 0 || p.count IS NULL) AS in_stock
FROM shop_product p
JOIN shop_search_index si
ON p.id = si.product_id
WHERE p.status = 1
AND si.word_id IN (3702,15443,20974)
GROUP BY p.id HAVING SUM(si.weight) >= 39) AS t