SELECT cities.arabic_city_name as city_name,pages_categories.cate_parent_category,main_page.category_name_ar as main_page_name ,pages_categories.category_name_ar as category_name, posts.*, users.user_name, users.user_firstname, users.user_lastname, users.user_gender, users.user_picture, users.user_picture_id, users.user_cover, users.user_cover_id, users.user_verified, users.user_subscribed, users.user_pinned_post, pages.*, groups.*, events.* FROM posts LEFT JOIN users ON posts.user_id = users.user_id AND posts.user_type = 'user' LEFT JOIN pages ON posts.page_id = pages.page_id AND posts.user_type = 'page' LEFT JOIN groups ON posts.in_group = '1' AND posts.group_id = groups.group_id LEFT JOIN events ON posts.in_event = '1' AND posts.event_id = events.event_id JOIN pages_categories ON pages.page_category = pages_categories.category_id JOIN pages_categories as main_page ON pages_categories.cate_parent_category = main_page.category_id JOIN cities ON posts.city_id = cities.id WHERE NOT (users.user_name <=> NULL AND pages.page_name <=> NULL) AND posts.post_id= '0' AND deleted_at IS NULL SELECT cities.arabic_city_name as city_name,pages_categories.cate_parent_category,main_page.category_name_ar as main_page_name ,pages_categories.category_name_ar as category_name, posts.*, users.user_name, users.user_firstname, users.user_lastname, users.user_gender, users.user_picture, users.user_picture_id, users.user_cover, users.user_cover_id, users.user_verified, users.user_subscribed, users.user_pinned_post, pages.*, groups.*, events.* FROM posts LEFT JOIN users ON posts.user_id = users.user_id AND posts.user_type = 'user' LEFT JOIN pages ON posts.page_id = pages.page_id AND posts.user_type = 'page' LEFT JOIN groups ON posts.in_group = '1' AND posts.group_id = groups.group_id LEFT JOIN events ON posts.in_event = '1' AND posts.event_id = events.event_id JOIN pages_categories ON pages.page_category = pages_categories.category_id JOIN pages_categories as main_page ON pages_categories.cate_parent_category = main_page.category_id JOIN cities ON posts.city_id = cities.id WHERE NOT (users.user_name <=> NULL AND pages.page_name <=> NULL) AND posts.post_id= '18291' AND deleted_at IS NULL 7d4fb110e Wa Aftakher
  • ذكر
  • 23/10/2018
  • المدينة : المنوفية
    السعر : 135000
    شقة فى شبرا الخيمة اول بلكونة فى بيت اهالى
    . قريبة من مسجد التوحيد ومن ارض المحلاوى اول نمرة فى شارع حيوى جدا
    مساحتها 60متر بمساحه خارجيه يمكن ضمها للشقه
    غرفتين وصالة غرفة كبيرة عبارة عن غرفتين مفتوحين على بعض وغرفة متوسطة وصالة ومطبخ وحمام وبها عداد ماية وكهربا عداد قديم ويمكن التقديم على غاز طبيعى بسهولة لان البيت كله فى غاز
    يمكن استخدامها #[2976] او #[2977] او #[2978] او #[1973] او #[2979] او #[2980] او #[2981] (محتاجة توضيبات بسيطة وتتأجر تجارى )

    0 نشر
    متابعة
    تعليق
    مشاركة
    رسالة
شاهد المزيد