SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.name as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=47 and c.published LIMIT 1
Ads arrow

$row->ad_headline

$row->ad_text
Price: $ $row->ad_price
Currency:
Contact:
>>> Log in to view all contact details <<<
nopic

Xperiences

Kashmir Zinda Baad Yaa Kashmir Se Zinda Baag
07 December 2008
article thumbnaiThis section like all other sections in Kashland is by our users. Here the users talk about their experience while in Kashmir. Some are still in Kashmir and some are settled in different corners of...

Heritage

Persian Legacy in Kashmir Struggles for Revival
05 December 2008 23:58
article thumbnaiConcerned at the alarming decline of Persian influence in Kashmir, a group of Kashmiri intellectuals have launched a campaign to restore the old glory of Persian heritage in Kashmir. In its campaign...

Ultimate Content Display

Poetry

Saen Posh Waer" Kasheer
28 February 2009
article thumbnaiYeth saeni posh waaray,Kamisanz laej nazar.Soragachi raazkumaray,Kamisanz laej nazar.

My Opinion

Saen Posh Waer" Kasheer
article thumbnaiYeth saeni posh waaray,Kamisanz laej nazar.Soragachi raazkumaray,Kamisanz laej nazar.

Copy of Ultimate Content Display

Login n' Connect

Hotels
Travel
Gifts
Mobile
Downloads
Jobs
Business
Yellow Pages
Shopping

Shout here...

Latest Message: 5 years, 8 months ago
  • jan mohammad : salaam to all
  • Fazal A : Lets celebrate jashne Nauroz at Badamwari today.. All are invited
  • Snow Storm : Salaam to ppl on kashland
  • Feroz Ahmad : is looking forward to the nightout
  • Burhaan Fare : the ikillings of innocents are goin on unabatedly..lso wat diiference does it make whthr we hav guv rule or elected govt..the forces are law unto themselves
  • Gul Dar : barbad shehras muen salaam
  • zahid Ahmed : when we stop follwing particular group of leaders
  • Saqib Mir : When will we grow as a nation & come as a one voice?
  • Mir Imran : You will receive a body. You may like it or hate it, but it's yours to keep for the entire period.

Only registered users are allowed to post

Latest Events

No current events.

Latest Comments