Cashback

Unknown column 'post_RAND' in 'order clause'(Errno=1054)

Your query: Get ID of next item

SELECT DISTINCT post_ID 

FROM evo_items__item INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                        INNER JOIN evo_categories ON postcat_cat_ID = cat_ID 

WHERE ( cat_blog_ID = 11 ) 

  AND (( post_ptyp_ID IS NULL
                        

  OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000) )) 

  AND (post_datestart <= '2012-05-18 15:13:17') 

  AND ( ( post_status IN ('published') ) ) 

ORDER BY post_R

  AND ASC, post_ID ASC 

LIMIT 1