select products.id, products.Cached_GetFirstPhoto, products.quick_url, products.productname_short, review.rating, review.summary, review.review, review.source, review.location, products.productPhoto, products.ShowstandardPicture, review.date_added, review.reply_from_hop, review.id, review.userID, products.upc, file_small, file_medium, products.ProductName, products.review_score, products.review_ratings, products.displayProduct, products.etadate, products.ProductUnit, products.upc, products.ProductShortDescription, products.ProductDescription, products.ProductCode from products, review, w3t_USER_PROFILE where review.review_item_id = products.ID AND review.userID= w3t_USER_PROFILE.USER_ID AND w3t_USER_PROFILE.user_show_reviews='1'AND approve = 'y' AND (products.displayProduct='yes' OR products.etadate<>'' OR products.ID='239') AND rating >= 0 ORDER BY rating ASC, date_added DESC LIMIT 0,30