SELECT `u`.`id`, `u`.`slug`, COALESCE(u.firstname, u2.firstname) as firstname, COALESCE(u.lastname, u2.lastname) as lastname, CASE when u.id is not null then 1 when u2.id is not null then 2 end as builder_type, CASE when u.id is not null then u.id when u2.id is not null then u2.id end as id, CASE when u.id is not null then u.slug when u2.id is not null then u2.slug end as slug
FROM `global_limo_listing` `l`
LEFT JOIN `global_limo_features_to_listing` `f2l2` ON `f2l2`.`listing_id`=`l`.`id`
LEFT JOIN `carmake_tbl` `cm` ON `cm`.`id`=`l`.`make`
LEFT JOIN `global_limo_features` `f11` ON `f11`.`id` = `f2l2`.`feature_id` and `f11`.`slug`='coach-builder' 
LEFT JOIN `tbl_users_make` `um` ON `um`.`make_id` = `l`.`make`
LEFT JOIN `tbl_users_builders` `ub` ON `ub`.`builder_id` = `f2l2`.`feature_value_id` and `f11`.`id` is not null
LEFT JOIN `global_limo_user` `u` ON `u`.`id` = `um`.`user_id` and `u`.`make_link_show`=1
LEFT JOIN `groups` `g` ON `g`.`id` = `u`.`group_id`
LEFT JOIN `global_limo_user` `u2` ON `u2`.`id` = `ub`.`user_id` and `u2`.`manufecture_link_show`=1
LEFT JOIN `groups` `g2` ON `g2`.`id` = `u2`.`group_id`
WHERE `l`.`id` = '2102'
AND `l`.`status` = 1
AND `l`.`is_deleted` =0
AND   (
   (
u.id is not null
AND g.id is not null
  )
OR    (
u2.id is not null
AND g2.id is not null
  )
 )
 LIMIT 1<pre>Array
(
    [flag] => 1
    [data] => Array
        (
            [name] => 2014 Mercedes Benz Sprinter
            [id] => 2102
            [video_url] => https://youtu.be/CVmOwtg1C6o?si=mHJMVfQsNxukKXkx
            [username] => Jonathan Cohen
            [firstname] => Jonathan
            [lastname] => Cohen
            [email] => odstitleloans@gmail.com
            [zipcode] => 
            [country] => USA
            [state] => Nevada
            [city] => Las Vegas
            [user_number] => 8187314885
            [meta_title] => 2014 Mercedes Benz Sprinter For Sale In Las Vegas, Global Limos Bus Sales
            [meta_description] => The 2014 Mercedes Benz Sprinter is available for sale in Las Vegas at a very reasonable price of $24,000.
            [description] => <p>2014 Mercedes-Benz Sprinter 2500 Passenger Van with a long wheelbase, featuring a powerful 3.0L V6 diesel engine. </p>

<p>Mileage: With only 141,000 miles on the odometer, this van has low mileage and no mechanical issues, ensuring a smooth and dependable driving experience.</p>

<p>Capacity: This high-top extended van accommodates up to 15 passengers, including the driver and co-driver, making it ideal for transportation companies, family outings, shuttle services, or business fleets.</p>

<p>The van is clean both inside and out, demonstrating the care it has received throughout its service life.</p>

<p>Currently located in Las Vegas, NV, this Sprinter is ready for work or travel and is available for nationwide shipping directly to your doorstep. </p>

<p>Price: Priced at $24,000, it’s an excellent opportunity for anyone in need of a reliable passenger vehicle. </p>

            [meta_keywords] => Mercedes Benz Sprinter For Sale In Las Vegas, Sprinter for sale, Mercedes Benz Sprinter For Sale In Las Vegas, Naveda
            [image_source] => cloud
            [user_email] => odstitleloans@gmail.com
            [slug] => 2014-mercedes-benz-sprinter-18
            [userid] => 689
            [short_description] => <p>2014 Mercedes-Benz Sprinter 2500 Passenger Van with a long wheelbase, featuring a powerful 3.0L V6 diesel engine with 141,000 miles for only $24,000.</p>\r\n
            [make_name] => Mercedes-Benz
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142317/photos/zlma6bkm0vgrchvhcbnr.jpg#403434
            [gallery] => Array
                (
                    [12181] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142316/photos/qjjhmfabbznfb6nrs4ms.jpg#1ab8e01c35cf609c5b93ed22e96bbe037543fba5
                    [12182] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142316/photos/mk8wde3hpslhmk07skyw.jpg#ae23a75d1aba9da85e346cf5ef959d90d280be07
                    [12184] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142317/photos/qrwz8wzdaaftdwbbszoz.jpg#a94a639bb0bf615ba1799c606954342453ec3355
                    [12185] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142317/photos/punnfxldzie5rhsfq9u8.jpg#66733b78fbd13bb072c63476728ddecfd59d05ad
                    [12186] => https://res.cloudinary.com/db54ocawg/image/upload/v1764142316/photos/fwod4jvmkck3mznsyseg.jpg#a47946
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 45687
                            [features] => Array
                                (
                                    [357] => 2014
                                )

                        )

                    [price] => Array
                        (
                            [feature_name] => Price
                            [display_type] => 4
                            [feature_id] => 11
                            [feature_values_id] => 45685
                            [features] => Array
                                (
                                    [24000] => 24000
                                )

                        )

                    [mileage] => Array
                        (
                            [feature_name] => Mileage
                            [display_type] => 4
                            [feature_id] => 13
                            [feature_values_id] => 45686
                            [features] => Array
                                (
                                    [141000] => 141000
                                )

                        )

                    [condition] => Array
                        (
                            [feature_name] => Condition
                            [display_type] => 2
                            [feature_id] => 14
                            [feature_values_id] => 45693
                            [features] => Array
                                (
                                    [473] => Used
                                )

                        )

                    [vin] => Array
                        (
                            [feature_name] => VIN
                            [display_type] => 4
                            [feature_id] => 15
                            [feature_values_id] => 45691
                            [features] => Array
                                (
                                    [0] => 
                                )

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 45684
                            [features] => Array
                                (
                                    [556] => 15
                                )

                        )

                    [exterior-color] => Array
                        (
                            [feature_name] => Exterior Color
                            [display_type] => 3
                            [feature_id] => 17
                            [feature_values_id] => 45688
                            [features] => Array
                                (
                                    [474] => Black
                                )

                        )

                    [transmission] => Array
                        (
                            [feature_name] => Transmission
                            [display_type] => 3
                            [feature_id] => 18
                            [feature_values_id] => 45690
                            [features] => Array
                                (
                                    [504] => Automatic
                                )

                        )

                    [drivetrain] => Array
                        (
                            [feature_name] => Drivetrain
                            [display_type] => 2
                            [feature_id] => 19
                            [feature_values_id] => 45692
                            [features] => Array
                                (
                                    [487] => 2WD
                                )

                        )

                    [mechanical-condition-rating] => Array
                        (
                            [feature_name] => Mechanical Rating
                            [display_type] => 3
                            [feature_id] => 31
                            [feature_values_id] => 45694
                            [features] => Array
                                (
                                    [518] => 9
                                )

                        )

                    [exterior-condition-rating] => Array
                        (
                            [feature_name] => Exterior Rating
                            [display_type] => 3
                            [feature_id] => 32
                            [feature_values_id] => 45695
                            [features] => Array
                                (
                                    [528] => 9
                                )

                        )

                    [interior-condition-rating] => Array
                        (
                            [feature_name] => Interior Rating
                            [display_type] => 3
                            [feature_id] => 33
                            [feature_values_id] => 45696
                            [features] => Array
                                (
                                    [538] => 9
                                )

                        )

                    [interior-color] => Array
                        (
                            [feature_name] => Interior  Color
                            [display_type] => 3
                            [feature_id] => 35
                            [feature_values_id] => 45689
                            [features] => Array
                                (
                                    [598] => Black
                                )

                        )

                )

            [is_sold] => 0
            [active] => 1
            [whatsapp] => 
            [facebook] => 
            [is_verified] => 1
            [acceptance] => 2
        )

)