Unable to list itemsSELECT spdv.*,spdf.FieldName,spdf.FieldCaption, sp.ProductID FROM subproducts_details_values spdv
LEFT JOIN subproducts_details_fields spdf ON (spdv.FieldID=spdf.id AND spdf.Deleted=0)
LEFT JOIN subproducts sp ON (spdv.SubProductID=sp.id AND sp.Deleted=0)
LEFT JOIN products p ON (sp.ProductID=p.id AND p.Deleted=0)
WHERE 1 AND spdv.`Deleted`=0 AND `FieldName`='ColourDetail' AND `Value`<>'' AND 1 AND sp .ProductID IN (0,1611,1500,1598,1528,1548,1601,1537,1498,1503,1508,1501,1504,1531,1579,1499,1593,1490,1527,1496,1597) ORDER BY `Value` Lost connection to MySQL server during query