A Database Error Occurred

Error Number: 1030

Got error 28 from storage engine

select i.* , (select count(id) from user_items where item_id = i.id and user_id=0) mylikecnt from items i, look_items li where i.view_yn = 'Y' and li.look_id in ( 58584,58448,56665,54127,53937,53857,53345,50027,50026,49695,49367,49332,49331,49281,49007,48657,48505,48504,48337,48222,48187,48060,47901,47729,47545,47470,47469,47418,47177,46876,46621,46312,46277,46107,45757,45756,45637,45591,45505,45473,45472,45339,45338,45220,45219,45197,45107,45039,44655,44614,44613,44576,44496,44452,44395,44394,44176,44175,44134,43959,43958,43872,43871,43774,43727,43710,43684,43683,43581,43548,43038,42958,42604,42500,42452,42314,42280,42279,42201,42178,42048,42047,41926,41925,41757,41756,41686,41500,41452,41451,41301,41256,41255,41211,41146,41143,41004,41000,40999,40938,40876,40875,40849,40848,40819,40755,40754,40575,40574,40471,40440,40406,40405,40211,40210,40085,40084,40076,40029,40011,39931,39882,39881,39571,39570,39394,39393,39251,39250,39020,39019,38905,38904,38775,38774,38539,38538,38398,38397,38396,38322,38224,38223,38085,38084,38037,37882,37878,37877,37876,37764,37746,37716,37715,37685,37606,37587,37586,37542,37510,37409,37400,37357,37356,37324,37222,37221,37138,37084,37041,37040,37039,37011,36862,36861,36644,36643,36482,36472,36441,36423,36408,36406,36348,36339,36338,36296,36199,36198,35944,35943,35937,35745,35719,35718,35697,35517,35516,35515,35490,35424,35423,35377,35195,35194,35177,34951,34950,34947,34902,34868,34774,34734,34719,34709,34689,34680,34671,34641,34620,34619,34609,34587,34557,34509,34428,34379,34378,34375,34331,34287,34246,34187,34167,34134,34133,34130,34088,34049,34048,34036,34012,34011,33943,33928,33927,33921,33894,33893,33886,33885,33822,33821,33817,33807,33785,33784,33740,33739,33638,33637,33601,33600,33598,33597,33561,33560,33518,33517,33468,33464,33385,33384,33372,33350,33348,33347,33334,33287,33255,33254,33219,33218,33179,33122,33105,33104,33051,33050,33027,33026,33006,33005,32978,32954,32952,32910,32909,32805,32804,32779,32778,32759,32758,32757,32713,32704,32647,32595,32562,32488,32457,32456,32454,32425,32398,32391,32345,32344,32229,32211,32210,32196,32184,32183,32145,32144,32125,32103,32102,32070,32069,31984,31965,31964,31962,31961,31910,31909,31895,31858,31857,31846,31804,31802,31801,31800,31799,31684,31683,31641,31638,31636,31613,31594,31593,31581,31580,31575,31563,31522,31521,31491,31468,31467,31437,31381,31357,31356,31323,31322,31298,31288,31287,31278,31277,31238,31237,31206,31205,31113,31112,31083,31082,31081,31080,30893,30891,30861,30860,30806,30805,30798,30763,30762,30725,30724,30629,30627,30586,30526,30463,30420,30415,30296,30295,30280,30245,30234,30205,30174,30128,30000,29945,29943,29897,29888,29833,29735,29667,29657,29613,29574,29530,29520,29401,29370,29325,29288,29274,29236,29103,29062,29054,29007,28995,28983,28948,28924,28920,28870,28799,28761,28712,28687,28648,28617,28549,28399,28355,28321,28319,28318,28286,28283,28239,28186,28175,28023,27997,27972,27965,27954,27944,27929,27910,27864,27792,27714,27664,27663,27612,27562,27519,27401,27387,27358,27341,27327,27272,27226,27104,27094,27068,27045,27043,27040,26985,26952,26912,26860,26797,26791,26790,26730,26698,26689,26596,26542,26539,26533,26520,26502,26469,26423,26319,26276,26273,26239,26199,26072,25925,25840,25830,25781,25762,25672,25602,25455,25435,25433,25414,25338,25334,25266,25252,24804,24792,24788,24682,24658,24630,24547,24284,24215,24213,24173,24167,24138,24122,24105,24074,23913,23897,23852,23834,23822,23813,23770,23710,23675,23627,23514,23491,23433,23425,23350,23290,23228,23075,23047,22973,22933,22928,22857,22838,22834,22832,22669,22658,22618,22549,22546,22506,22424,22418,22282,22232,22199,22183,22155,22109,22010,21965,21919,21883,21853,21848,21735,21700,21666,21619,21583,21447,21421,21397,21390,21376,21331,21290,21222,21217,21094,21085,21056,21034,21032,21025,21018,20970,20959,20918,20915,20872,20870,20857,20790,20665,20639,20619,20560,20508,20476,20467,20302,20230,20184,20176,20125,20123,20076,20070,20055,20045,20042,20006,19951,19895,19748,19715,19714,19653,19592,19578,19574,19468,19234,19197,19147,19063,18983,18926,18900,18849,18828,18796,18778,18732,18685,18636,18610,18608,18597,18570,18506,18400,18340,18283,18277,18219,18175,18164,18152,17945,17900,17816,17811,17753,17736,17734,17728,17620,17523,17411,17350,17345,17339,17283,17140,17065,17001,16929,16867,16686,16622,16612,16531,16432,16371,16359,16349,16007,15908,15820,15743,15734,15731,15675,15669,15664,15581,15569,15451,15117,15084,15073,15002,14813,14769,14646,14495,14461,14130,14098,14017,13745,13743,13734,13676,13613,13605,13547,13457,13451,13423,13169,13157,13150,13090,13081,12966,12862,12773,12707,12665,12650,12637,12630,12621,12549,12545,12357,12242,12187,12163,12148,11913,11885,11874,11747,11731,11725,11691,11659,11643,11633,11410,11372,11317,11306,11300,11262,11255,11248,11228,11154,11140,11116,11047,10980,10972,10918,10904,10864,10824,10765,10724,10686,10635,10598,10402,10400,10338,10325,10182,10143,10004,9948,9945,9844,9805,9775,9774,9648,9606,9604,9498,9386,9355,9310,9260,9228,9221,9209,9207,9134,9057,8974,8908,8806,8536,8390,8375,8366,8345,8266,8259,8132,8131,8126,8110,8086,7867,7792,7735,7727,7722,7604,7452,7271,7270,7198,7161,7118,7089,7075,7073,6995,6949,6882,6820,6806,6798,6788,6787,6745,6650,6644,6535,6516,6491,6415,6413,6407,6389,6345,6335,6242,6236,6194,6096,6058,6050,6025,5806,5779,5750,5696,5692,5691,5689,5676,5652,5639,5637,5594,5588,5558,5532,5523,5458,5439,5428,5366,5365,5364,5315,5306,5279,5250,5243,5227,5212,5210,5207,5206,5183,5121,5116,5113,5096,5085,5013,4982,4971,4962,4940,4914,4848,4835,4826,4808,4807,4800,4791,4761,4721,4666,4631,4606,4595,4592,4488,4440,4420,4389,4343,4325,4320,4302,4298,4297,4240,4154,4131,4099,4089,4080,4070,4016,3996,3995,3994,3987,3950,3945,3935,3901,3842,3841,3759,3750,3685,3673,3671,3667,3660,3652,3646,3644,3608,3595,3592,3570,3564,3560,3551,3549,3535,3522,3481,3442,3437,3398,3381,3357,3346,3304,3303,3290,3281,3259,3251,3237,3222,3212,3210,3205,3186,3118,3111,3091,3073,3070,3050,3045,3042,3039,3037,3034,3000,2962,2924,2910,2898,2894,2809,2767,2714,2711,2706,2698,2656,2602,2597,2571,2455,2450,2425,2407,2393,2382,2373,2344,2335,2328,2254,2248,2246,2243,2230,2229,2227,2221,2215,2196,2184,2159,2093,2083,2070,2057,2050,2046,2044,2023,2013,2008,1969,1956,1942,1941,1931,1906,1895,1884,1868,1841,1840,1837,1808,1792,1745,1737,1733,1729,1721,1699,1694,1689,1687,1674,1670,1663,1645,1640,1620,1618,1601,1584,1573,1566,1564,1557,1544,1495,1487,1454,1442,1424,1420,1405,1383,1379,1369,1368,1367,1319,1308,1302,1293,1289,1280,1263,1256,1250,1235,1228,1213,1206,1197,1178,1173,1138,1101,1083,1072,1065,1057,1049,1047,1033,942,912,868,758,723,712,615,461,458,457,455,337,328,326,321,320,309,306,297,290 ) and li.item_id <> 2098 and li.item_id = i.id and substring( i.category_cd, 1, 2) = '01' group by i.id order by i.like_cnt desc, i.created_at desc limit 9

Filename: controllers/item.php

Line Number: 556