SELECT products.id, products.productname, products.productshortdescription, products.productthumb, products.productUnit, product_price.singleprice, product_price.unitprice, product_price.discountpercent, products.popular, products.Productphoto, products.ShowStandardPicture, products.headline, products.DisplayProduct, products.etadate, products.ProductCode, products.review_score, products.review_ratings, products.LimitPurchase, products.quick_url, products_in_language.productname_short, product_price.Tenprice, product_price.Cartonprice, products.digitally_shipped, products.Cached_GetFirstPhoto, products.dropship, products.w1, products.wholesale, products.upc, products_in_language.ProductShortDescription, product_price.UnitWeight, product_price.SingleWeight, products.show_a_review, products.show_a_review_last_time, product_catergories_mesh.show_top_listitems FROM products JOIN product_price ON products.id = product_price.productid JOIN product_catergories_mesh ON products.id = product_catergories_mesh.productID JOIN products_in_language ON products.ProductCode = products_in_language.ProductCode WHERE products.stock_or_sell IN ('sell','retail') AND (products.displayProduct LIKE 'yes' OR products.etadate<>'' ) AND product_catergories_mesh.categoryID=230 AND products_in_language.language_id = 6 order by products.DisplayProduct DESC, product_catergories_mesh.show_top_listItems DESC, products.Order_by_popularity DESC, product_price.discountpercent DESC, product_price.singleprice, product_price.unitprice