Всего выполнено запросов: 17 шт. за 0.1741 сек. Закрыть


Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) as category_url, p.url as product_url, p.*, pv.product_id as variant_exist, rate,(p.price_course + p.price_course * (IFNULL(rate,0))) as `price_course` FROM `mg_product` p LEFT JOIN `mg_category` c ON c.id = p.cat_id LEFT JOIN `mg_product_variant` pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM( pv.count ) AS varcount FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE (p.cat_id IN (21,495,499,627,501,496,569,498,500,509,553,563,562,72,73,75,604,62,71,74,67,64,554,561,535,556,558,557,536,560,40,555,41,65,559,414,371,415,69,70,68,668,23,566,66,63,565,564,37,39,61,38,35,370,36,537,538,22,253,401,655,568,377,379,404,380,381,382,383,406,408,24,26,125,138,135,712,126,713,27,131,694,139,142,686,132,34,129,140,157,25,127,141,156,128,696,33,133,137,136,688,134,628,246,28,595,32,608,91,609,31,225,648,188,189,661,187,711,190,654,29,224,610,223,116,662,191,53,651,30,192,612,194,613,193,641,92,629,163,420,660,145,144,393,508,687,663,692,398,93,664,488,639,427,626,43,44,79,672,78,603,515,574,80,685,464,601,45,103,670,81,669,516,575,83,619,465,600,47,104,673,105,517,576,84,605,466,602,46,522,577,675,85,521,578,674,524,526,579,527,580,528,581,529,582,525,583,532,584,530,585,531,586,49,89,106,647,268,598,87,615,375,86,88,50,611,476,571,714,477,676,90,677,107,594,426,520,573,51,572,597,416,109,111,110,403,261,113,114,596,186,599,54,95,653,82,652,282,643,100,58,640,77,271,646,272,376,638,275,97,277,269,270,667,702,59,98,276,273,274,683,94,428,438,423,384,396,510,666,533,55,102,644,56,101,645,693,57,76,607,421,513,540,284,519,630,195,99,481,482,618,483,642,123,164,168,170,171,167,172,165,169,166,448,283,523,108,620,217,218,463,418,504,219,588,491,280,221,247,262,248,249,636,399,689,267,250,467,616,286,478,485,637,486,631,487,632,288,505,506,507,287,292,290,634,289,291,468,635,514,633,690,544,549,550,567,552,546,545,703,551,547,548,623,622,260,441,442,450,695,443,440,458,446,449,453,452,457,444,454,445,455,447,456,433,385,434,704,435,705,437,706,659,707,439,691,462,708,512,709,624,710,294,295,304,305,299,332,333,334,335,336,337,338,339,340,341,342,301,348,349,350,351,352,353,354,355,356,357,296,310,311,313,314,312,308,316,309,306,307,315,317,318,319,320,369,298,327,328,329,330,331,297,321,322,323,324,325,326,300,343,344,345,346,347,302,358,359,360,361,362,366,367,303,363,364,365,244,158,238,235,237,236,160,239,240,159,233,251,252,589,410,590,543,684,117,118,234,174,175,625,176,177,518,183,178,650,184,222,173,368,122,120,665,263,121,255,254,256,592,257,258,161,281,649,181,591,493,489,373,372,422,431,480,617,407,405,593,180,259,700,196,198,204,201,202,203,199,200,265,206,470,205,207,197,432,469,413,471,472,473,474,475,492,494,539,658,682,484,151,479,152,162,698,155,153,185,699,147,148,150,149,264,386,390,387,388,389,391,397,266,242,243,241,208,209,210,678,232,211,681,392,417,374,587,402,226,657,534,671,245,701,228,570,227,230,229,231,215,656,278,212,680,279,606,216,213,614,214,697,419,400,409,411,679,412,424,425,429,502,511,542,490,503,0) or FIND_IN_SET(0,p.`inside_cat`)) AND p.activity = 1 AND (temp.`varcount` > 0 OR temp.`varcount` < 0 OR p.count>0 OR p.count<0) ORDER BY `price_course` asc
Got error 28 from storage engine


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/navigator.php (line 99)


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/navigator.php (line 50)


/var/www/akbaline/data/www/akba-line.ru/mg-core/models/catalog.php (line 174)


/var/www/akbaline/data/www/akba-line.ru/mg-core/controllers/catalog.php (line 109)


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/moguta.php(35) : eval()'d code(1) : eval()'d code(49) : eval()'d code (line 11)


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/moguta.php(35) : eval()'d code(1) : eval()'d code (line 49)


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/moguta.php(35) : eval()'d code (line 1)


/var/www/akbaline/data/www/akba-line.ru/mg-core/lib/moguta.php (line 35)


/var/www/akbaline/data/www/akba-line.ru/mg-core/mg-start.php (line 50)


/var/www/akbaline/data/www/akba-line.ru/index.php (line 78)