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 ( Ads2RegionCities.RegionCitiesID='737' ) and Ads.Category='30'
) as Ads
order by
Top desc, Ads.DateTimeCustomOrder asc
limit
0, 15
Error writing file '/tmp/MYfd=511' (OS errno 28 - No space left on device)