SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '483'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2061' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
1SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1093'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1093'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2062' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1089'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1089'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2063' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
2SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1114'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1114'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2042' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
3SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '483'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2049' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
4SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1092'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1092'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2058' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
5SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '483'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2059' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
6SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1104'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1104'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2038' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
7SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '483'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='483'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2050' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'
8SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_en as country, ctregion.name2_en as region, ctregion.id as reg_id, ctlocation.name2_en as location, ctlocation.id as loc_id, ctlocation_ids.new_id as new_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto
FROM cars
INNER JOIN ctcountry ON ctcountry.id='61'
INNER JOIN ctregion ON ctregion.id = 14
INNER JOIN ctlocation ON ctlocation.id = '1089'
INNER JOIN ctlocation_ids ON ctlocation_ids.location_id='1089'
INNER JOIN groups ON cars.group_id = groups.group_id
INNER JOIN pricelists ON cars.group_id = pricelists.group_id
INNER JOIN periods ON pricelists.period_id = periods.period_id
WHERE cars.car_id = '2048' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND ctlocation_ids.brand_id='1' AND ctlocation_ids.level='R'