Unable to run pageCount (1)MySQL server has gone awaySELECT count(DISTINCT pdv.id) as recCount FROM products_details_values pdv
INNER JOIN products p ON (pdv.ProductID=p.id AND p.Deleted=0)
INNER JOIN products_details_fields pdf ON (pdv.FieldID=pdf.id AND pdf.Deleted=0)
LEFT JOIN products_details_fieldoptions pdfo ON (pdv.ValueID=pdfo.id AND pdfo.Deleted=0)
LEFT JOIN products parent ON (parent.id=p.ParentProductID AND parent.Deleted=0)
WHERE 1 AND pdv.`Deleted`=0 AND `FieldName`='Manufacturedin' AND `Value`<>'' AND ( p.CategoryID1 IN (20,55,21,29,10,39,5,16,26,49,40,12,54,52,43,24,32,28,53,50,15,44,9,22,51,31,47,45,13,8,42,23) OR p.CategoryID2 IN (20,55,21,29,10,39,5,16,26,49,40,12,54,52,43,24,32,28,53,50,15,44,9,22,51,31,47,45,13,8,42,23) )
AND p.ProductVisibleCache=1 AND ( (p.ParentProductID=0 AND p.HasSubProducts=0) OR
(p.ParentProductID>0 AND p.ShowVariationsInListing=1) OR
(p.ParentProductID=0 AND p.HasSubProducts>0 AND p.ShowVariationsInListing=0) ) AND p.Visible=1 AND pdv.ProductID IN (0,670,444,217,1221,1218,722,491,690,425,440,1210,1215,454,627,1211,1212,1213,1214,786,639,725,685,688,623,713,783,784,453,703,1222,1219,469,687,430,1216,456,694,479,731,490,695,679,427,466,715,692,437,734,693,726,745,458,461,737,482,443,628,701,691,719,720,439,514,495,503,452,704,1223,1220,468,678,729,429,1217,455,632,635,478,709,489,696,680,426,441,465,716,630,436,735,651,727,746,457,460,738,481,442,629,424,677,683,438,513,732,502,669,599,721,723,724,451,705,467,633,477,710,488,730,473,464,754,611,631,435,652,728,459,739,698,423,624,512,494,501,744,736,606,607,1209,603,73,450,706,626,634,636,476,711,487,484,472,681,463,717,682,653,740,480,674,625,434,511,493,500,71,72,65,76,449,707,67,428,475,486,471,699,741,510,492,499,66,609,77,80,448,637,474,485,697,700,647,742,433,509,498,612,733,74,79,216,447,69,470,462,743,508,497,702,68,81,718,75,608,70,684,446,638,64,432,507,496,714,63,686,62,712,59,61,708,445,60,506,747,58,57,689,56,55,54,660,431,53,505,748,749,750,504,751,752,753)