Error: 500 - Unknown column 'lastname' in 'order clause' SQL=SELECT a.*,loc.name AS location,c.title AS cattitle, c.alias AS catalias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM `d953x_abbook` AS a LEFT JOIN d953x_ablocations AS loc ON loc.id=a.idlocation LEFT JOIN d953x_abcategories AS c ON c.id = a.catid LEFT JOIN d953x_abrating AS v ON a.id = v.book_id WHERE a.access IN (1,1) AND a.catid =9 AND c.access IN (1,1) AND (a.state = 1 OR a.state = 2) GROUP BY a.id ORDER BY lastname ASC Unknown column 'lastname' in 'order clause' SQL=SELECT a.*,loc.name AS location,c.title AS cattitle, c.alias AS catalias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM `d953x_abbook` AS a LEFT JOIN d953x_ablocations AS loc ON loc.id=a.idlocation LEFT JOIN d953x_abcategories AS c ON c.id = a.catid LEFT JOIN d953x_abrating AS v ON a.id = v.book_id WHERE a.access IN (1,1) AND a.catid =9 AND c.access IN (1,1) AND (a.state = 1 OR a.state = 2) GROUP BY a.id ORDER BY lastname ASC LIMIT 0, 20 Unknown column 'lastname' in 'order clause' SQL=SELECT a.*,loc.name AS location,c.title AS cattitle, c.alias AS catalias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM `d953x_abbook` AS a LEFT JOIN d953x_ablocations AS loc ON loc.id=a.idlocation LEFT JOIN d953x_abcategories AS c ON c.id = a.catid LEFT JOIN d953x_abrating AS v ON a.id = v.book_id WHERE a.access IN (1,1) AND a.catid =9 AND c.access IN (1,1) AND (a.state = 1 OR a.state = 2) GROUP BY a.id ORDER BY lastname ASC

You may not be able to visit this page because of:

  1. an out-of-date bookmark/favourite
  2. a search engine that has an out-of-date listing for this site
  3. a mistyped address
  4. you have no access to this page
  5. The requested resource was not found.
  6. An error has occurred while processing your request.

← Home