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 ( 58697,58696,58695,58678,58677,58676,58659,58658,58589,58588,58587,58550,58549,58548,58513,58512,58511,58500,58499,58498,58463,58462,58461,58444,58443,58442,58406,58405,58404,58129,58128,58127,58022,58021,58020,57965,57964,57936,57740,57739,57738,57705,57704,57703,57673,57672,57671,57653,57652,57651,57620,57619,57618,57565,57564,57545,57544,57543,57534,57533,57532,57513,57512,57511,57486,57485,57484,57458,57457,57456,57422,57421,57420,57394,57393,57392,57371,57370,57369,57343,57342,57341,57319,57318,57317,57297,57296,57295,57269,57268,57267,57257,57256,57255,57194,57193,57192,56991,56990,56989,56874,56873,56872,56837,56823,56804,56803,56802,56786,56785,56784,56757,56756,56755,56725,56724,56723,56710,56709,56708,56685,56684,56683,56652,56651,56650,56618,56617,56613,56599,56598,56597,56531,56530,56497,56496,56495,56475,56473,56472,56438,56437,56436,56423,56422,56421,56384,56383,56382,56369,56368,56367,56351,56350,56348,56301,56300,56299,56271,56270,56269,56253,56252,56251,56231,56230,56229,56213,56212,56211,56207,56206,56205,56184,56183,56181,56171,56169,56168,56154,56153,56152,56136,56135,56134,56107,56106,56105,56082,56081,56080,56068,56067,56066,56051,56050,56049,56027,56026,56025,56002,56001,56000,55996,55995,55994,55977,55976,55975,55962,55961,55960,55925,55924,55923,55905,55904,55903,55837,55835,55834,55787,55786,55785,55766,55765,55764,55739,55738,55737,55708,55707,55706,55676,55675,55674,55660,55657,55656,55641,55640,55639,55606,55605,55604,55572,55571,55570,55549,55548,55547,55500,55499,55498,55454,55453,55452,55430,55429,55428,55381,55380,55379,55366,55365,55364,55341,55340,55339,55316,55315,55314,55296,55295,55294,55267,55266,55265,55260,55259,55258,55213,55212,55211,55205,55204,55203,55197,55196,55195,55181,55180,55179,55157,55156,55155,55137,55136,55135,55126,55124,55123,55103,55102,55101,55083,55082,55081,55068,55067,55066,55052,55051,55050,55029,55027,55026,55013,55012,55011,54973,54972,54971,54939,54938,54937,54925,54924,54922,54903,54902,54901,54890,54889,54888,54871,54870,54869,54843,54842,54841,54822,54821,54820,54802,54801,54800,54761,54759,54758,54710,54709,54708,54690,54689,54688,54661,54660,54659,54623,54622,54621,54607,54606,54605,54583,54582,54581,54571,54570,54569,54551,54550,54549,54523,54522,54521,54508,54507,54506,54480,54479,54478,54462,54461,54460,54455,54442,54441,54440,54404,54403,54402,54386,54385,54384,54348,54347,54346,54336,54335,54334,54309,54308,54307,54278,54277,54276,54260,54259,54258,54244,54243,54242,54205,54204,54203,54186,54185,54184,54162,54161,54160,54140,54139,54138,54115,54114,54113,54100,54099,54098,54070,54069,54068,54051,54050,54049,54036,54035,54034,54018,54017,54016,53993,53992,53991,53968,53967,53966,53934,53933,53932,53895,53894,53893,53882,53881,53880,53870,53869,53868,53855,53854,53853,53810,53809,53808,53794,53793,53792,53780,53779,53778,53765,53764,53763,53750,53749,53748,53737,53736,53735,53716,53715,53714,53685,53684,53683,53666,53665,53664,53646,53645,53644,53634,53633,53632,53612,53611,53610,53590,53589,53588,53580,53579,53578,53568,53567,53566,53556,53555,53554,53519,53518,53517,53504,53503,53502,53479,53478,53477,53418,53417,53416,53407,53406,53405,53372,53371,53370,53360,53359,53358,53312,53311,53310,53287,53286,53285,53265,53264,53263,53252,53251,53250,53191,53190,53189,53174,53173,53172,53148,53147,53146,53132,53131,53130,53123,53115,53113,53092,53091,53090,53078,53077,53076,53064,53063,53062,53052,53051,53050,53037,53036,53035,53012,53011,53010,53002,53001,53000,52977,52976,52975,52927,52926,52925,52901,52900,52899,52876,52875,52874,52860,52859,52858,52840,52839,52838,52808,52807,52806,52790,52789,52788,52772,52771,52770,52754,52752,52751,52723,52722,52721,52706,52705,52704,52692,52691,52690,52680,52679,52678,52615,52614,52613,52578,52577,52576,52489,52488,52487,52474,52473,52472,52451,52450,52449,52411,52410,52409,52370,52369,52368,52355,52354,52353,52346,52345,52344,52324,52323,52322,52281,52280,52279,52260,52259,52258,52203,52202,52201,52184,52183,52182,52112,52111,52110,52067,52066,52065,52036,52035,52034,52016,52015,52014,51967,51966,51965,51952,51951,51950,51930,51927,51926,51892,51891,51890,51860,51859,51858,51852,51851,51850,51835,51834,51833,51822,51820,51818,51796,51795,51794,51776,51774,51773,51760,51759,51758,51734,51733,51732,51695,51694,51693,51678,51677,51676,51663,51662,51661,51650,51649,51648,51631,51630,51629,51599,51598,51583,51582,51581,51564,51563,51562,51539,51538,51537,51510,51509,51508,51495,51494,51493,51482,51481,51480,51466,51465,51464,51451,51450,51449,51422,51419,51418,51404,51403,51402,51389,51388,51387,51375,51374,51373,51348,51347,51346,51320,51319,51318,51263,51262,51261,51245,51244,51243,51227,51226,51225,51209,51208,51207,51190,51189,51188,51151,51150,51149,51136,51135,51134,51118,51117,51116,51103,51102,51101,51083,51082,51081,51040,51039,51037,51013,51012,51011,50994,50993,50992,50927,50926,50925,50905,50904,50903,50889,50888,50887,50822,50821,50820,50808,50807,50806,50795,50794,50793,50771,50770,50769,50721,50720,50700,50698,50697,50617,50616,50615,50592,50591,50590,50546,50545,50544,50526,50525,50524,50497,50496,50495,50474,50473,50472,50448,50447,50446,50432,50431,50430,50405,50404,50391,50390,50389,50360,50359,50358,50326,50325,50324,50313,50312,50311,50293,50292,50291,50274,50272,50266,50245,50244,50243,50194,50193,50192,50176,50175,50174,50147,50146,50145,50118,50117,50116,50096,50095,50094,50066,50065,50064,50024,50023,50022,50003,50002,50001,49984,49983,49982,49952,49951,49950,49938,49937,49936,49916,49915,49914,49892,49891,49890,49872,49871,49870,49824,49823,49822,49801,49800,49799,49779,49778,49777,49764,49763,49762,49753,49752,49751,49714,49713,49712,49694,49693,49692,49673,49672,49670,49647,49646,49645,49581,49580,49579,49559,49558,49557,49535,49534,49533,49510,49509,49508,49488,49487,49486,49474,49473,49472,49457,49456,49455,49431,49430,49429,49407,49406,49405,49391,49390,49389,49373,49372,49371,49345,49344,49343,49328,49327,49326,49291,49290,49289,49271,49270,49269,49247,49246,49245,49227,49225,49224,49199,49198,49197,49167,49166,49165,49151,49150,49149,49122,49121,49120,49093,49092,49091,49081,49080,49079,49068,49067,49066,49049,49048,49047,49032,49031,49030,48990,48989,48988,48973,48972,48971,48953,48952,48951,48930,48929,48928,48904,48903,48902,48872,48871,48870,48853,48852,48851,48822,48817,48816,48801,48800,48799,48780,48779,48778,48734,48732,48731,48721,48720,48719,48706,48705,48704,48689,48688,48687,48655,48654,48653,48594,48593,48592,48564,48563,48562,48543,48542,48541,48519,48518,48517,48501,48500,48499,48461,48460,48459,48439,48438,48437,48417,48416,48415,48393,48392,48391,48354,48353,48352,48336,48335,48334,48314,48313,48312,48294,48293,48292,48259,48258,48257,48219,48218,48217,48186,48185,48184,48150,48149,48148,48127,48126,48125,48084,48083,48082,48059,48058,48057,48021,48020,48019,47995,47994,47993,47970,47969,47968,47928,47927,47926,47900,47899,47898,47877,47876,47875,47856,47855,47854,47838,47837,47836,47786,47785,47784,47763,47762,47761,47728,47727,47726,47704,47703,47702,47685,47684,47683,47662,47661,47660,47630,47629,47628,47610,47609,47595,47594,47593,47569,47568,47567,47544,47543,47542,47521,47520,47519,47511,47506,47505,47487,47486,47485,47467,47466,47465,47375,47374,47373,47360,47359,47358,47337,47336,47335,47319,47318,47317,47273,47272,47271,47238,47237,47236,47222,47221,47220,47198,47197,47196,47160,47159,47158,47120,47119,47118,47102,47101,47100,47080,47079,47078,47050,47049,47048,47031,47030,47029,47008,47007,47006,46988,46987,46986,46965,46964,46963,46939,46938,46937,46918,46917,46916,46895,46894,46893,46872,46871,46870,46852,46851,46850,46830,46829,46828,46800,46799,46798,46746,46745,46744,46727,46726,46725,46703,46702,46701,46684,46683,46682,46654,46653,46652,46617,46616,46615,46591,46590,46589,46568,46567,46566,46540,46539,46538,46511,46510,46509,46491,46490,46489,46457,46456,46455,46438,46437,46436,46416,46415,46414,46393,46392,46391,46367,46366,46365,46330,46329,46328,46311,46310,46309,46295,46294,46293,46275,46274,46273,46218,46217,46216,46200,46199,46198,46173,46172,46171,46156,46155,46154,46130,46129,46128,46106,46105,46104,46093,46092,46091,46064,46063,46062,46046,46045,46044,46022,46021,46020,45990,45989,45988,45982,45981,45980,45940,45939,45938,45920,45919,45918,45917,45896,45895,45894,45868,45867,45866,45846,45844,45843,45819,45818,45817,45788,45787,45786,45754,45753,45752,45688,45687,45686,45660,45659,45658,45634,45633,45632,45590,45589,45588,45566,45565,45564,45538,45536,45535,45504,45503,45502,45469,45468,45467,45426,45425,45424,45406,45405,45404,45384,45383,45382,45367,45366,45365,45364,45335,45334,45333,45295,45294,45293,45264,45263,45262,45238,45237,45236,45217,45216,45215,45177,45176,45175,45159,45158,45157,45130,45129,45128,45095,45094,45093,45036,45035,45034,44981,44980,44979,44960,44959,44958,44933,44930,44929,44905,44904,44903,44881,44880,44879,44845,44844,44843,44829,44827,44826,44806,44805,44804,44790,44788,44787,44762,44759,44758,44731,44730,44729,44699,44698,44697,44663,44662,44661,44633,44632,44631,44611,44610,44609,44584,44583,44582,44564,44563,44562,44543,44542,44541,44526,44525,44524,44494,44493,44492,44459,44457,44456,44438,44437,44436,44391,44389,44388,44354,44353,44352,44338,44337,44336,44321,44320,44319,44301,44300,44299,44276,44275,44274,44254,44253,44252,44235,44234,44233,44215,44214,44213,44196,44195,44194,44174,44173,44172,44127,44126,44125,44076,44075,44074,44052,44051,44050,44028,44027,44026,43988,43987,43986,43952,43951,43950,43920,43919,43918,43898,43897,43896,43883,43882,43881,43859,43858,43857,43806,43805,43804,43789,43788,43787,43762,43761,43760,43736,43735,43734,43699,43698,43697,43681,43680,43679,43657,43656,43655,43641,43640,43639,43619,43618,43617,43570,43569,43568,43546,43545,43544,43529,43528,43527,43503,43502,43501,43440,43439,43438,43434,43433,43432,43350,43349,43348,43321,43320,43319,43301,43300,43299,43247,43246,43245,43221,43220,43219,43200,43199,43198,43182,43181,43180,43132,43131,43130,43111,43110,43109,43094,43093,43092,43055,43054,43053,43035,43034,43033,43016,43015,43014,43000,42999,42998,42982,42981,42980,42965,42964,42963,42947,42946,42945,42919,42918,42917,42902,42900,42899,42882,42881,42880,42872,42871,42870,42855,42854,42853,42809,42808,42807,42795,42794,42793,42778,42777,42776,42758,42757,42756,42733,42732,42731,42710,42702,42700,42684,42683,42682,42668,42656,42655,42636,42635,42634,42602,42601,42600,42569,42568,42567,42539,42538,42537,42513,42512,42511,42482,42480,42479,42451,42449,42447,42417,42416,42415,42388,42387,42386,42367,42366,42365,42340,42339,42338,42311,42310,42309,42263,42262,42261,42235,42234,42233,42225,42217,42216,42198,42197,42196,42170,42169,42168,42131,42130,42129,42116,42115,42114,42089,42088,42087,42068,42067,42066,42044,42043,42042,41991,41990,41989,41977,41976,41975,41954,41953,41952,41923,41922,41921,41884,41883,41882,41861,41860,41859,41837,41836,41835,41778,41777,41776,41755,41754,41753,41730,41729,41728,41684,41683,41682,41654,41653,41652,41603,41602,41601,41582,41581,41580,41556,41555,41554,41535,41534,41533,41512,41511,41510,41468,41467,41466,41449,41448,41447,41435,41434,41433,41413,41412,41411,41388,41387,41386,41343,41342,41341,41322,41321,41320,41300,41299,41298,41279,41278,41277,41253,41252,41251,41223,41222,41221,41210,41207,41206,41191,41190,41189,41173,41172,41171,41140,41139,41138,41090,41088,41085,41052,41051,41050,41020,41019,41018,40996,40995,40994,40954,40953,40952,40934,40933,40932,40889,40888,40887,40878,40877,40874,40836,40835,40834,40818,40817,40816,40787,40786,40785,40765,40764,40763,40742,40722,40721,40688,40687,40686,40646,40645,40644,40617,40616,40615,40600,40599,40598,40566,40565,40564,40493,40492,40491,40469,40468,40467,40439,40438,40437,40424,40423,40422,40403,40402,40401,40354,40353,40352,40326,40325,40324,40302,40301,40300,40283,40281,40280,40250,40249,40248,40208,40207,40206,40177,40176,40175,40149,40147,40146,40107,40106,40105,40073,40072,40071,40013,40012,40010,39974,39973,39972,39930,39929,39928,39912,39911,39910,39887,39885,39884,39759,39758,39757,39736,39735,39734,39679,39678,39677,39647,39646,39645,39608,39607,39606,39556,39555,39554,39521,39520,39519,39512,39491,39490,39489,39466,39465,39464,39445,39444,39443,39392,39391,39390,39371,39370,39369,39332,39331,39330,39299,39298,39297,39247,39246,39245,39205,39204,39203,39180,39179,39178,39149,39148,39147,39124,39123,39122,39101,39100,39099,39034,39033,39032,39004,39003,39002,38974,38973,38972,38954,38953,38952,38928,38903,38902,38901,38867,38866,38865,38838,38835,38834,38794,38793,38792,38771,38770,38769,38711,38710,38688,38687,38686,38665,38664,38663,38630,38629,38628,38593,38592,38591,38553,38552,38551,38530,38529,38528,38497,38496,38495,38460,38459,38458,38387,38386,38385,38358,38357,38356,38331,38330,38329,38300,38299,38298,38248,38247,38246,38228,38227,38200,38166,38165,38164,38128,38127,38126,38079,38078,38076,38036,38035,38034,38013,38012,38010,37971,37969,37968,37938,37921,37920,37898,37896,37895,37855,37854,37853,37834,37833,37832,37801,37800,37799,37779,37778,37777,37749,37748,37747,37699,37698,37697,37671,37670,37669,37637,37636,37635,37609,37608,37607,37583,37582,37581,37535,37534,37533,37502,37501,37500,37475,37474,37473,37450,37449,37448,37414,37413,37412,37354,37353,37352,37332,37329,37328,37311,37310,37309,37284,37283,37282,37250,37249,37248,37215,37214,37213,37192,37191,37190,37163,37162,37161,37142,37141,37140,37113,37112,37111,37055,37054,37053,37031,37030,37029,37005,37004,37003,36981,36980,36979,36952,36951,36950,36903,36902,36901,36859,36858,36857,36825,36824,36823,36787,36785,36784,36757,36756,36755,36647,36646,36645,36577,36576,36575,36554,36553,36552,36528,36527,36526,36491,36490,36489,36464,36463,36462,36393,36392,36391,36335,36331,36329,36286,36285,36284,36260,36258,36257,36220,36219,36218,36150,36149,36148,36122,36121,36120,36092,36091,36090,36057,36056,36055,36013,36012,36011,35942,35940,35939,35917,35916,35915,35881,35878,35877,35865,35854,35853,35851,35816,35815,35814,35805,35732,35731,35730,35715,35714,35707,35667,35666,35665,35637,35636,35635,35609,35608,35607,35529,35528,35527,35498,35497,35496,35462,35461,35460,35438,35437,35436,35414,35413,35412,35319,35318,35317,35298,35297,35296,35279,35272,35271,35270,35193,35192,35191,35143,35140,35139,35120,35119,35118,35076,35074,35073,34998,34997,34996,34949,34948,34947,34905,34903,34902,34892,34870,34869,34868,34776,34775,34774,34691,34690,34689,34643,34642,34641,34594,34588,34587,34558,34557,34556,34511,34510,34509,34430,34429,34428,34389,34377,34376,34375,34333,34332,34331,34290,34288,34287,34248,34247,34246,34169,34168,34167,34132,34131,34130,34090,34089,34088,34050,34049,34048,34013,34012,34011,33931,33928,33927,33921,33890,33886,33885,33823,33822,33821,33787,33785,33784,33741,33740,33739,33644,33638,33637,33622,33599,33598,33597,33562,33561,33560,33519,33518,33517,33468,33466,33464,33386,33385,33384,33335,33334,33333,33288,33287,33286,33256,33255,33254,33220,33219,33218,33112,33106,33105,33104,33052,33051,33050,33009,33006,33005,32955,32954,32952,32911,32910,32909,32806,32805,32804,32760,32759,32758,32714,32713,32712,32648,32647,32646,32596,32595,32594,32489,32488,32487,32475,32455,32454,32453,32426,32425,32424,32398,32392,32391,32346,32345,32344,32212,32211,32210,32146,32145,32144,32104,32103,32102,32071,32070,32069,31966,31963,31962,31961,31911,31910,31909,31859,31858,31857,31803,31802,31801,31685,31684,31683,31654,31642,31641,31638,31582,31581,31580,31523,31522,31521,31469,31468,31467,31358,31357,31356,31338,31324,31323,31322,31279,31278,31277,31239,31238,31237,31207,31206,31205,31114,31113,31112,31085,31084,31083,31082,30895,30893,30891,30862,30861,30860,30807,30806,30805,30764,30763,30762,30726,30725,30724,30637,30629,30627,30589,30588,30587,30586,30528,30527,30526,30465,30464,30463,30417,30416,30415,30283,30282,30280,30249,30247,30246,30245,30207,30206,30205,30176,30175,30174,30130,30129,30128,30003,30001,30000,29947,29946,29945,29890,29889,29888,29835,29834,29833,29668,29667,29615,29614,29613,29576,29575,29574,29532,29531,29530,29403,29402,29401,29373,29372,29371,29370,29326,29325,29290,29289,29288,29238,29237,29236,29107,29104,29103,29060,29056,29055,29054,29042,28985,28984,28983,28928,28927,28924,28872,28871,28870,28799,28770,28763,28762,28761,28714,28713,28712,28651,28650,28648,28644,28619,28618,28617,28551,28550,28549,28401,28400,28399,28358,28356,28355,28318,28289,28288,28286,28241,28240,28239,28190,28188,28186,28025,28024,28023,27967,27966,27965,27929,27914,27913,27910,27867,27865,27864,27794,27793,27792,27716,27715,27714,27666,27665,27664,27663,27614,27613,27612,27563,27562,27523,27521,27519,27403,27402,27401,27364,27359,27358,27341,27329,27328,27327,27274,27273,27272,27229,27227,27226,27108,27106,27104,27048,27047,27045,27043,26987,26986,26985,26954,26953,26952,26916,26913,26912,26797,26795,26792,26791,26790,26732,26731,26730,26698,26691,26690,26689,26598,26597,26596,26541,26540,26539,26520,26504,26503,26502,26475,26470,26469,26425,26424,26423,26321,26320,26319,26276,26275,26274,26273,26241,26240,26239,26201,26200,26199,26074,26073,26072,25926,25925,25831,25830,25781,25764,25763,25762,25675,25674,25672,25604,25603,25602,25416,25415,25414,25340,25339,25338,25334,25328,25266,25254,25253,25252,24792,24791,24789,24788,24661,24660,24658,24632,24631,24630,24549,24548,24547,24287,24285,24284,24217,24216,24215,24213,24175,24174,24173,24129,24126,24122,24076,24075,24074,24044,23899,23898,23897,23852,23838,23835,23834,23772,23771,23770,23714,23711,23710,23677,23676,23675,23516,23515,23514,23428,23427,23425,23352,23351,23350,23292,23291,23290,23238,23229,23228,23129,23080,23076,23075,23048,23047,22975,22974,22973,22931,22929,22928,22859,22858,22857,22664,22663,22658,22630,22620,22619,22618,22548,22547,22546,22508,22507,22506,22422,22419,22418,22284,22283,22282,22235,22234,22232,22186,22185,22183,22157,22156,22155,22111,22110,22109,22030,22012,22010,21968,21966,21965,21921,21920,21919,21886,21885,21883,21851,21849,21848,21736,21735,21703,21701,21700,21668,21667,21666,21621,21620,21619,21584,21583,21449,21448,21447,21395,21392,21390,21336,21333,21331,21292,21291,21290,21224,21218,21217,21058,21057,21056,21021,21020,21018,20962,20961,20959,20920,20916,20915,20859,20858,20857,20667,20666,20665,20625,20621,20619,20562,20560,20516,20510,20508,20469,20467,20303,20302,20231,20230,20177,20176,20125,20124,20123,20071,20070,19750,19748,19654,19653,19576,19574,19457,19236,19234,19148,19147,19065,19063,18984,18983,18901,18900,18779,18778,18733,18732,18686,18685,18638,18636,18571,18570,18401,18400,18340,18333,18278,18277,18264,18220,18219,18153,18152,18098,18032,18031,17984,17946,17945,17903,17900,17830,17812,17811,17729,17728,17524,17523,17412,17411,17360,17340,17339,17313,17283,17264,17218,17141,17140,17121,17068,17065,17004,17001,16930,16929,16868,16867,16689,16686,16616,16612,16533,16531,16434,16432,16396,16361,16359,16192,16191,16100,16099,16043,16042,15982,15980,15899,15898,15771,15748,15718,15716,15643,15562,15483,15400,15191,15111,15036,14956,14874,14841,14783,14709,14647,14588,14523,14457,14411,14302,14209,14136,14128,14051,13982,13927,13874,13822,13745,13675,13614,13545,13503,13452,13400,13336,13249,13169,13152,13150,13060,12976,12974,12880,12832,12828,12784,12783,12718,12717,12715,12665,12640,12637,12636,12559,12556,12502,12501,12454,12357,12355,12286,12285,12263,12256,12163,12156,12101,12025,12020,11876,11875,11864,11845,11772,11768,11432,11431,10391,9551,8729,6978,6655,6382,5559,5558,4962,4429,3216,2370,1251,730,292 ) and li.item_id <> 2101 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