Error: MySQL server has gone away
Error No: 2006
SELECT p.product_id, p.model, p.tax_class_id, p.price, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating,
(SELECT price FROM mod_product_price mpp WHERE p.product_id = mpp.product_id AND mpp.customer_id = '0') AS mprice
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id)
WHERE pd.language_id = '1' AND ss.language_id = '1'AND p.product_id IN (97, 2124, 1296, 1427, 1428, 1295, 1301, 607, 1298, 1299, 1293, 1292, 1429, 1426, 1300, 1294, 1297, 1088, 609, 1565, 1614, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 1639, 1641, 1642, 1645, 1646, 1647, 1648, 1649, 1651, 1653, 1654, 1655, 1656, 1657, 1658, 1659, 1660, 1661, 1662, 1663, 1664, 1665, 1666, 1667, 1668, 1670, 1671, 1673, 1674, 1675, 1676, 1677, 1678, 1679, 1680, 1681, 1682, 1683, 1684, 1685, 1687, 1688, 1689, 1690, 1691, 1692, 1693, 1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1703, 1716, 1711, 1717, 2122, 1773, 1777, 1778, 1779, 1763, 1780, 1781, 1709, 1784, 1785, 1788, 1789, 1790, 1791, 1792, 1793, 1794, 1798, 1797, 1796, 1867, 1868, 1974, 1973, 1976, 1975, 1978, 1977, 1979, 1980, 1981, 1982, 1994, 1995, 1997, 1998, 1999, 2000, 2002, 2057, 2058, 2060, 2061, 2062, 202, 605, 2064, 2067, 2068, 2069, 2071, 2072, 144, 2074, 2075, 2076, 2077, 2079, 2081, 2082, 2083, 2085, 2087, 2088, 2090, 2092, 2094, 2101, 2102, 2103, 2105, 2109, 2110, 2111, 2113, 2114, 2091, 2089, 1704, 2093, 606, 599, 1718, 608, 1686, 2073, 2078, 2084, 2106, 2059, 2063, 522, 532, 1672, 1669, 2146, 2356, 2408, 2433, 2434, 2435, 2578, 2589, 504) AND p.status = '1' AND p.date_available <= NOW() ORDER BY pd.name ASC LIMIT 0,150