Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'way2ad_indiaclass.p.url' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byQuery:SELECT c.category,a.id,a.title,a.opt_price,a.video,a.price,a.id_cat,p.url FRoM ann_categories c,ann_photos p left join ann_annonces a on a.id=p.id_ann WHERE a.publi=1 and a.id_cat=c.id_cat AND a.`id` IN (SELECT id_ann FROM ann_ad_city WHERE id_city = 1) group by a.id order by p.date desc limit 8Erreur #6006 - Please contact site administrator Free classifieds India, buy, sell and rent accomodation
Other cities: Delhi, Noida, Pune, Mumbai, Hyderabad, Lucknow, Goa, Shillong, Kolkata, Gurgaon, Dehradun, Guwahati, Surat, Chandigarh, Bhubaneswar, Nashik, Lucknow, Indore, Chennai, Coimbatore, Madurai, Ludhiana, Jaipur, Kochi, Nagpur, Kanpur, Tamil Nadu, Kerala, Karnataka, Jharkhand, Haryana, Gujarat, Himachal Pradesh, Uttaranchal, Manipur



< All ads

Book 2/3/4bhk... (17 days ago)INR 2147483647Get 2/3/4bhk... (32 days ago)INR 5993000
@9250002253... (18 days ago)INR 6300000Mahagun meadows... (33 days ago)INR 7550000
Elite golf... (18 days ago)INR 4675000Get ready to... (33 days ago)INR 3591000
Book your home... (19 days ago)INR 10275000Home based job... (36 days ago)Please contact
At_9250002253... (19 days ago)INR 7900000Ats picturesque... (36 days ago)INR 10100000
Affordable... (21 days ago)INR 1528000Rajhans... (36 days ago)INR 3065000
@9266850850... (21 days ago)INR 3065000Bhutani... (37 days ago)INR 1100000
M3m corner walk... (22 days ago)INR 7000000Affordable... (44 days ago)INR 1100000
Gulshan botnia... (22 days ago)INR 5200000Godrej solitaire... (45 days ago)INR 10600000
Online jobs |... (24 days ago)INR 625002Godrej golf link... (45 days ago)INR 14000000
Book @9266850850... (24 days ago)INR 14000000Stunning 3bhk... (46 days ago)INR 10275000
Ats picturesque... (24 days ago)INR 2147483647Lockable shops... (46 days ago)INR 2200000
Ats pristine... (28 days ago)INR 10275000@9278057805... (46 days ago)INR 8300000
Ajnara the... (28 days ago)INR 6099000Antriksh golf... (47 days ago)INR 4462000
Earn healthy... (30 days ago)INR 23000Ajnara belvedere... (47 days ago)INR 6099000
Smart has the... (31 days ago)INR 20000Ajnara daffodil... (47 days ago)INR 10000000

< Photo ads

Book 2/3/4BHK Flats @9278057805 At Godrej Nest Sec 150 Noida Book 2/3/4bhk flats... (17 days ago)
Godrej Nest Sector 150 Noida new luxurious residential property by Godrej Properties a trustworthy name in Real...
Category: housing for...INR2147483647
@9250002253 Godrej Nest Luxury 2BHK Apartments in Noida 150 @9250002253 godrej... (18 days ago)
Godrej Nest a new launched residential property by Godrej Properties in Noida. Godrej Nest 150 Noida has been offered...
Category: housing for...INR6300000
Elite Golf Greens Noida @9266850850 | 2/3/4/5 BHK Starts @46.75 Lacs Elite golf greens... (18 days ago)
Elite Golf Greens is the best new residendial project strategically located in Sector 79, Sports City, Noida. Elite...
Category: housing for...INR4675000
Book Your Home @9266850850 in ATS Pristine Sector 150 Noida Expressway Book your home... (19 days ago)
For natural and healthy living style on best location offering as ATS Pristine Apartments in Sector 150 Noida...
Category: housing for...INR10275000
At_9250002253 Get ATS Le Grandiose 3/4BHK Apartments At_9250002253 get... (19 days ago)
In wide and huge acres the ATS Le Grandiose Apartments is available in Sector 150 Noida on Noida expressway. With...
Category: housing for...INR7900000
Affordable Apartments @9266850850 In Shri Radh Sky Park Greater Noida Affordable... (21 days ago)
Most advanced with high technology has been used in the Shri Radha Sky Park Apartments located in Greater Noida. Never...
Category: housing for...INR1528000
< Map



advanced search


Search forexact phrase
Category
Area
Price INR to
With Photo

Change city


Help | About | Dubai Classifieds | Privacy Policy | Contact us | Copyright 2008-17 Way2Ad.net |
web counter
web counter
way2ad.net Webutation