Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT `location_district`.`id`,
- `location_district`.`name`,
- `location_district`.`name_ru`,
- `location_district`.`name_en`,
- `location_district`.`nameslug`,
- `location_district`.`lat`,
- `location_district`.`lon`,
- `location_district`.`zoom`,
- `location_district`.`country_id`,
- `location_district`.`region_id`,
- `location_district`.`city_id`
- FROM `location_district`
- WHERE `location_district`.`id` IN
- (SELECT U3.`district_id`
- FROM `transport_vehicle` U0
- INNER JOIN `transport_vehiclepark` U1 ON (U0.`park_id` = U1.`id`)
- LEFT OUTER JOIN `gpsreceiver_vehiclegpsreceiver` U2 ON (U0.`gps_supplier_id` = U2.`id`)
- INNER JOIN `transport_vehicleenterprise` U3 ON (U1.`enterprise_id` = U3.`id`)
- WHERE (U0.`id` LIKE '%29555%'
- OR U0.`registration_code` LIKE '%29555%'
- OR U1.`name` LIKE '%29555%'
- OR U0.`park_code` LIKE '%29555%'
- OR U2.`name` LIKE '%29555%'
- OR U2.`code` LIKE '%29555%'
- OR U0.`gps_device_code` LIKE '%29555%'))
- ORDER BY `location_district`.`name` ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement