IP: - 194.60.254.175 - 165.225.206.77; TIME:2024-10-31 08:14:13; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=276) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name asc IP: - 178.136.252.99 - 165.225.206.86; TIME:2024-10-31 08:18:04; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=292 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=292) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 178.136.252.99 - 165.225.206.86; TIME:2024-10-31 08:22:20; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=292 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=292) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 93.175.194.138 - 165.225.200.94; TIME:2024-10-31 08:54:25; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=292 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=292) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.93.45.223 - 136.226.198.119; TIME:2024-10-31 09:07:12; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=290 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=290) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 93.175.194.138 - 165.225.200.94; TIME:2024-10-31 09:26:03; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=292 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=292) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 10:05:58; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.93.45.223 - 136.226.198.119; TIME:2024-10-31 10:16:18; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=290 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=290) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 82.207.53.218 - 147.161.248.94; TIME:2024-10-31 10:16:19; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=276) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name asc IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 10:20:31; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 12:32:02; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 12:33:43; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 12:57:26; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 12:58:13; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 12:58:50; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 188.163.35.113 - 165.225.206.101; TIME:2024-10-31 13:01:21; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=291 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=291) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 188.163.35.113 - 165.225.206.101; TIME:2024-10-31 13:08:50; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=291 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=291) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:24:06; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:34:32; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:40:47; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:43:13; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:43:44; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:44:07; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:45:36; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:45:42; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:46:09; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 82.207.53.218 - 147.161.248.94; TIME:2024-10-31 13:47:15; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=276) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name asc IP: - 77.222.130.227 - 147.161.248.122; TIME:2024-10-31 13:47:42; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=289 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=289) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC; IP: - 93.175.194.138 - 147.161.248.93; TIME:2024-10-31 14:28:11; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_group_ref` gr ON gr.`car_id`=ci.`id` INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=292 INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=292) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name ASC;