Invalid query: select
* from (
select
Ads.*,
Ads.Phone as Phones,
Regions.Name as AdministrativeAreaName,
if(Ads.OrganisationID<>'', CatItems.Name, 'частное лицо') as Organisation,
AdsCategories.NameLong as Categories,
AdsCategories.Name as CategoryName,
AdsCategories.dir as cat_dir,
Ads.TOPTariffEnd as Top,
RegionCities.LocalityName
from
Ads2RegionCities
left join
Ads
on
Ads.__id = Ads2RegionCities.AdsItemID
left join
AdsCategories
on
AdsCategories.__id = Ads.Category
left join
Regions
on
Regions.__id = Ads.RegionID
left join
CatItems
on
CatItems.__id = Ads.OrganisationID
left join
RegionCities
on
RegionCities.__id = Ads2RegionCities.RegionCitiesID
where
Ads.Active='1'
AND Ads.AdsType='1' AND Ads.RegionID='23' AND Ads.Category='1'
) as Ads
order by
Top desc, Ads.DateTimeCustomOrder asc
limit
0, 10
Error writing file '/tmp/MYfd=511' (OS errno 28 - No space left on device)