SELECT fetch_data.id AS fetch_data_id,
fetch_data.year,
fetch_data.month,
fetch_data.week,
fetch_data.day,
fetch_data.minute,
fetch_data.full_date,
fetch_data.category_id,
fetch_data.town_id,
fetch_data.company_id,
fetch_data.url,
fetch_data.data,
fetch_data.front_url,
fetch_data.pattern_id,
fetch_data.swedish_church_id,
fetch_data.sub_town_id,
fetch_data.img_url,
company.company,
company.company_sortorder,
category.category,
town.town,
town.town_url_name,
town.country,
geonames_town.latitude,
geonames_town.longitude,
geonames_nearby.address,
geonames_nearby.id
FROM fetch_data
LEFT JOIN company ON fetch_data.company_id=company.company_id
LEFT JOIN category ON fetch_data.category_id=category.category_id
LEFT JOIN town ON town.town_id=fetch_data.town_id
LEFT JOIN geonames_town ON geonames_town.town_id=fetch_data.town_id
LEFT JOIN geonames_nearby ON geonames_nearby.id=fetch_data.sub_town_id WHERE (((town.town_id > 0) AND year= '2026' AND (month= '03' AND day=0 OR week= '11' OR (month= '03' AND day= '13' )))) AND country= 0 ORDER BY fetch_data.full_date,company.company_sortorder DESC LIMIT 1000