Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /home/www/tailofthelion/getprods.txt on line 399
Query to select qualifying product details--whether Cushion Options--failed: Server shutdown in progress
SELECT P.ProductID, MIN(GSC.AttributeNameID) AS CushionOptionNameID FROM Product P INNER JOIN AttributeGroupSearch GSC ON P.ProductID = GSC.ProductID INNER JOIN AttributeName NC ON GSC.AttributeNameID = NC.AttributeNameID WHERE P.ProductID IN (8729,8731,8728,8733,8730) && NC.AttributeName LIKE "%Cushion%" GROUP BY P.ProductID