SELECT SQL_CALC_FOUND_ROWS Listing.*, review.avgrating, review.countrating, Report_Listing.views FROM Listing left JOIN ( SELECT item_id, avg( rating ) AS avgrating, count( rating ) AS countrating FROM `Review` WHERE approved =1 GROUP BY item_id ) review ON Listing.id = review.item_id left JOIN ( SELECT listing_id, sum( report_amount ) AS views FROM `Report_Listing` WHERE 1 GROUP BY listing_id ) Report_Listing ON Listing.id = Report_Listing.listing_id WHERE Listing.status = 'A' AND (Listing.estado_id = 237 AND Listing.cidade_id = 3430) ORDER BY avgrating desc, review.countrating desc, Report_Listing.views DESC, Listing.level DESC, Listing.random_number DESC, Listing.title, Listing.id LIMIT 0,10 0 ERROR: http://www.tudoporaqui.com.br/results.php Query: SELECT SQL_CALC_FOUND_ROWS Listing.*, review.avgrating, review.countrating, Report_Listing.views FROM Listing left JOIN ( SELECT item_id, avg( rating ) AS avgrating, count( rating ) AS countrating FROM `Review` WHERE approved =1 GROUP BY item_id ) review ON Listing.id = review.item_id left JOIN ( SELECT listing_id, sum( report_amount ) AS views FROM `Report_Listing` WHERE 1 GROUP BY listing_id ) Report_Listing ON Listing.id = Report_Listing.listing_id WHERE Listing.status = 'A' AND (Listing.estado_id = 237 AND Listing.cidade_id = 3430) ORDER BY avgrating desc, review.countrating desc, Report_Listing.views DESC, Listing.level DESC, Listing.random_number DESC, Listing.title, Listing.id LIMIT 0,10 Errno: 144 Error: Table './tudoporaqui/Report_Listing' is marked as crashed and last (automatic?) repair failed _SERVER data REMOTE_ADDR : 44.200.171.74 REMOTE_PORT : 58816 SCRIPT_FILENAME : /home/storage/b/c3/71/tudoporaqui/public_html/tudoporaqui/results.php REQUEST_METHOD : GET QUERY_STRING : nome_do_estado=&nome_da_cidade=&cidade_atual=&bairro_atual=&estado_id=237&cidade_id=3430&bairro_id=&keyword=+ REQUEST_URI : /resultados?nome_do_estado=&nome_da_cidade=&cidade_atual=&bairro_atual=&estado_id=237&cidade_id=3430&bairro_id=&keyword=+
Nenhum resultado foi encontrado com o seu critério de busca. Por favor, tente sua busca novamente.