SELECT post.post_id, post.post_title, post.post_slug, post.post_summary, post.post_date, post.img_thumb, count((SELECT comment.comment_id FROM comment WHERE comment.post_id = post.post_id LIMIT 1)) num_comments, (SELECT author_name FROM author WHERE author_id = post.author_id LIMIT 1)author_name, (SELECT catname.category_name FROM category AS catname WHERE post_category.category_id = catname.category_id LIMIT 1) category_name, (SELECT catname.category_parent FROM category AS catname WHERE post_category.category_id = catname.category_id LIMIT 1)category_parent_id, (SELECT cat.category_name FROM category AS cat WHERE cat.category_id = category_parent_id) category_parent FROM post_tag LEFT JOIN post ON post_tag.post_id = post.post_id LEFT JOIN post_category ON post_tag.post_id = post_category.post_id WHERE post_tag.tag_id in (SELECT tag_id FROM tag WHERE tag_name='Tiran Island') GROUP BY post.post_id3
Articles Results for “Tiran Island” 3 results
Photo Galleries Results for “Tiran Island” 1 results
Straight from our Journal
Best Restaurant Downtown Cairo, Oriental Dishes Of Egypt Written by Christine Ghobrial // 09 Jul, 2012

Travel is not enjoyable unless you get to really taste and feel the traditional oriental local experiences of people and...

Read More.
Subscribe To Our Newsletter

Subscribe to our newsletter and get exclusive materials you wont find anywhere else straight to your inbox!


About Egyptolution

How Egyptolution has come to pace with Egyptian travel is an interesting story that was born as a result of Egypt after the Revolution of Jan25, 2011; and with the new rise of Egypt, a new partnership of travel novelty has taken place between Malak Mitch, Founder and Managing Director, and I (Christine Ghobrial, Managing Editor) where we have decided together to build a new threshold of communication ... Read More.


Copyright 2013 Egyptolution. All Rights Reserved. Powered by The Holidyers App. Developed by MitchDesigns