WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1320,30' at line 28]
SELECT wp_posts.ID, wp_posts.post_title, wp_posts.post_title, author.display_name, author.user_login,
COALESCE(likes.count, 0) as total_likes,
meta_feature.meta_value as featured, meta_price.meta_value as price, meta_views.meta_value as views,
(SELECT COUNT(id) FROM wp_job_orders WHERE wp_job_orders.pid = wp_posts.ID AND completed=1) as order_count,
(SELECT SUM(ratings.grade) AS rating FROM wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid=wp_posts.ID AND
ratings.awarded='1' AND orders.id=ratings.orderid AND ratings.grade=1) as good,
(SELECT count(ratings.id) as total from wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid = wp_posts.ID AND
ratings.awarded='1' AND orders.id=ratings.orderid ) AS totals,
CASE WHEN
((((SELECT SUM(ratings.grade) AS rating FROM wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid=wp_posts.ID AND ratings.awarded='1' AND orders.id=ratings.orderid AND ratings.grade=1)*100)/(SELECT count(ratings.id) as total from wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid = wp_posts.ID AND ratings.awarded='1' AND orders.id=ratings.orderid ))-80) > 0 THEN ((((SELECT SUM(ratings.grade) AS rating FROM wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid=wp_posts.ID AND ratings.awarded='1' AND orders.id=ratings.orderid AND ratings.grade=1)*100)/(SELECT count(ratings.id) as total from wp_job_ratings ratings, wp_job_orders orders WHERE orders.pid = wp_posts.ID AND ratings.awarded='1' AND orders.id=ratings.orderid ))-80) ELSE 0 END as rgood
FROM wp_posts
INNER JOIN wp_postmeta meta_active ON (wp_posts.ID = meta_active.post_id AND meta_active.meta_key='active' AND meta_active.meta_value=1)
INNER JOIN wp_postmeta meta_feature ON (wp_posts.ID = meta_feature.post_id AND meta_feature.meta_key='featured')
INNER JOIN wp_postmeta meta_feature_until ON (wp_posts.ID = meta_feature_until.post_id AND meta_feature_until.meta_key='featured_until')
INNER JOIN wp_postmeta meta_views ON (wp_posts.ID = meta_views.post_id AND meta_views.meta_key='views')
INNER JOIN wp_postmeta meta_likes ON (wp_posts.ID = meta_likes.post_id AND meta_likes.meta_key='likes')
INNER JOIN wp_postmeta meta_promoted ON (wp_posts.ID = meta_promoted.post_id AND meta_promoted.meta_key='promoted')
INNER JOIN wp_users author ON (wp_posts.post_author = author.ID)
LEFT JOIN wp_postmeta meta_price ON (wp_posts.ID = meta_price.post_id AND meta_price.meta_key='price')
LEFT JOIN (SELECT COUNT(*) as `count`, `pid` FROM wp_job_likes GROUP BY pid) as likes ON likes.pid=wp_posts.ID
WHERE
wp_posts.ID IN
(SELECT wp_term_relationships.object_id
FROM wp_terms,wp_term_relationships,wp_term_taxonomy
WHERE wp_terms.term_id = wp_term_taxonomy.term_id AND wp_terms.slug='photoshop' AND wp_term_relationships.term_taxonomy_id=wp_term_taxonomy.term_taxonomy_id
)
AND wp_posts.post_status='publish'
ORDER BY LIMIT 1320,30
