SELECT ( 3959 * ACOS( COS( RADIANS('39.0853') ) * COS( RADIANS( p.latitude ) ) * COS( RADIANS( p.longtitude ) - RADIANS('-77.6452') ) + SIN( RADIANS('39.0853') ) * SIN( RADIANS( p.latitude ) ) ) ) AS distance, p.latitude AS PLAT, p.longtitude AS PLONG, p.dateAdded AS postdated, p.postID,p.postDesc,p.postAddr,p.postImage1,p.postCity,p.postTitle,p.postZip,p.postPhone,p.postMobile, p.cityID,p.freePost, c.categoryID,c.parentID,c.categoryTitle,c.categoryTitle_zh,c.list_view_visibility,c.list_comments_visibility,c.categoryTitle_zh AS CATEGORY, ct.cityName,ct.cityName_zh,st.stateName,st.stateName_zh,st.stateAbbr,st.stateAbbr_zh, c.categoryTitle_zh AS CATEGORY, ct.cityName_zh AS CITY, st.stateName_zh AS STATE, st.stateAbbr_zh AS STATEABBR, cnt.countryName_zh AS COUNTRY FROM mx_post AS p LEFT JOIN `mx_category` AS c ON p.categoryID = c.categoryID LEFT JOIN `mx_city` AS ct ON p.cityID=ct.cityID LEFT JOIN `mx_state` AS st ON p.stateID=st.stateID LEFT JOIN `mx_country` AS cnt ON p.countryID = cnt.countryID WHERE p.categoryID in(388,389,390,391,392,393,417) AND p.status=1 AND p.approved=1 AND p.freePost>3 AND p.postStepCompleted = '2' AND ((p.postToReview=1 AND p.postReviewed=1) OR (p.postToReview=0 AND p.postReviewed=0)) AND FIND_IN_SET(29, p.premiumRegion) AND (p.premiumRegion!=' ' AND p.premiumRegion!='' AND p.premiumRegion!=0) ORDER BY RAND(),p.freePost DESC,distance ASC,p.dateAdded DESC LIMIT 3
SELECT ( 3959 * ACOS( COS( RADIANS('39.0853') ) * COS( RADIANS( p.latitude ) ) * COS( RADIANS( p.longtitude ) - RADIANS('-77.6452') ) + SIN( RADIANS('39.0853') ) * SIN( RADIANS( p.latitude ) ) ) ) AS distance, p.latitude AS PLAT, p.longtitude AS PLONG, p.dateAdded AS postdated, p.postID,p.postDesc,p.postAddr,p.postImage1,p.postCity,p.postTitle,p.postZip,p.postPhone,p.postMobile, p.cityID,p.freePost, c.categoryID,c.parentID,c.categoryTitle,c.categoryTitle_zh,c.list_view_visibility,c.list_comments_visibility,c.categoryTitle_zh AS CATEGORY, ct.cityName,ct.cityName_zh,st.stateName,st.stateName_zh,st.stateAbbr,st.stateAbbr_zh, c.categoryTitle_zh AS CATEGORY, ct.cityName_zh AS CITY, st.stateName_zh AS STATE, st.stateAbbr_zh AS STATEABBR, cnt.countryName_zh AS COUNTRY FROM mx_post AS p LEFT JOIN `mx_category` AS c ON p.categoryID = c.categoryID LEFT JOIN `mx_city` AS ct ON p.cityID=ct.cityID LEFT JOIN `mx_state` AS st ON p.stateID=st.stateID LEFT JOIN `mx_country` AS cnt ON p.countryID = cnt.countryID WHERE p.categoryID in(388,389,390,391,392,393,417) AND p.status=1 AND p.approved=1 AND p.freePost>3 AND p.postStepCompleted = '2' AND ((p.postToReview=1 AND p.postReviewed=1) OR (p.postToReview=0 AND p.postReviewed=0)) AND FIND_IN_SET(29, p.premiumRegion) AND (p.premiumRegion!=' ' AND p.premiumRegion!='' AND p.premiumRegion!=0) ORDER BY RAND(),p.freePost DESC,distance ASC,p.dateAdded DESC LIMIT 3
Got error 28 from storage engine