1. Share Product
    Share via E-Mail Share on Facebook Share on Twitter
  2. Previous
    Property 2 of 8
    This Property was added to our catalog on Friday 30 August, 2013.

    Apartment For Sale in Adma
    Agent Reference: [A 2026]
    Location: [Kesrwan]
    Bedrooms: [4]
    Bathrooms: [4]
    Size: [294 m2]

    Our Price:  $750,000

    Luxury apartment that consists on 3 master bedrooms,5 bathrooms,1 living room,2 salons,1 dining room in addition to a maid room.A heating system and a/c.2 underground parking and cave.
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'salamehe_property.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '401' and opa.orders_id = opb.orders_id and opb.products_id != '401' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 8