|
MySQL Error: Error#1030 : Got error 28 from storage engine SQL: SELECT distinct r.id, r.title, r.description, r.author, r.video, r.best_cat, r.prep_time, r.cook_time, reviews.rating, rg.thumb, cat.name as catname FROM recipe as r LEFT JOIN rel_item_cat as rel ON r.id=rel.it_id LEFT JOIN reviews ON r.id = recipe_id LEFT JOIN rec_graphic as rg ON r.id = rg.id LEFT JOIN rel_cat rcat ON r.best_cat=rcat.relid LEFT JOIN category cat ON cat.catid=rcat.lev3 WHERE rel.cat_id IN ('', '12509', '12508', '12507', '12506', '12505', '12504', '12503', '12502', '12501', '12500', '12499', '12498', '12497', '12496', '12703', '12704', '12705', '12706', '12791', '12792', '12793', '12794', '12795', '12796', '12797', '12798', '12799', '12800', '12801', '12802', '13034', '13035', '13036', '13307') AND r.id = rel.it_id AND rel.table_name = 'recipe' AND rel.id_name = 'id' GROUP BY r.id |
| Blog | FAQ | | Member Login |
|
MySQL Error: Error#1030 : Got error 28 from storage engine SQL: SELECT distinct r.id, r.title, r.description, r.author, r.video, r.best_cat, r.prep_time, r.cook_time, reviews.rating, rg.thumb, cat.name as catname FROM recipe as r LEFT JOIN rel_item_cat as rel ON r.id=rel.it_id LEFT JOIN reviews ON r.id = recipe_id LEFT JOIN rec_graphic as rg ON r.id = rg.id LEFT JOIN rel_cat rcat ON r.best_cat=rcat.relid LEFT JOIN category cat ON cat.catid=rcat.lev3 WHERE rel.cat_id IN ('', '12509', '12508', '12507', '12506', '12505', '12504', '12503', '12502', '12501', '12500', '12499', '12498', '12497', '12496', '12703', '12704', '12705', '12706', '12791', '12792', '12793', '12794', '12795', '12796', '12797', '12798', '12799', '12800', '12801', '12802', '13034', '13035', '13036', '13307') AND r.id = rel.it_id AND rel.table_name = 'recipe' AND rel.id_name = 'id' GROUP BY r.id |