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` = '2140'
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] => 2017 Cadillac XTS Limousine
            [id] => 2140
            [video_url] => https://youtu.be/0cd8ysa2r4Y?si=h1EUtJGgQnAMStUz
            [username] => Jonathan Cohen
            [firstname] => Jonathan
            [lastname] => Cohen
            [email] => odstitleloans@gmail.com
            [zipcode] => 
            [country] => USA
            [state] => Nevada
            [city] => 
            [user_number] => 8187314885
            [meta_title] => 2017 Cadillac XTS Limousine For Sale in Las Vegas, Global Limos Limo Sales
            [meta_description] => The 2017 Cadillac XTS Limousine is available for sale in Las Vegas at a very reasonable price of $17,500.
            [description] => <p>Experience luxury and elegance with the 2017 Cadillac XTS 4-Door Limousine, custom-built by Royal Coach Builder for maximum style and comfort. </p>

<p>This exquisite vehicle, available in Las Vegas, NV, is perfect for private hire, special events, or personal luxury travel, with ample space and sophisticated features. </p>

<p>Capacity: It comfortably seats 6 passengers with plush leather interiors, ambient lighting that sets a refined mood, and a smooth, glide-like ride for an enjoyable journey. </p>

<p>The limousine is in near-new condition, meticulously maintained by a single owner from a fleet, with regular servicing ensuring optimal performance. Its well-preserved exterior shows no rust, and the interior is spotless, reflecting careful upkeep.</p>

<p>Each unit boasts low mileage between 130,000 and 135,000 miles, and they are fully serviced and ready to operate, with a clean title and no issues.</p>

<p>Key features include GPS navigation for easy routing, a power divider for privacy, a backup camera for safety, tinted windows, and fiber optic lighting to enhance the ambiance.</p>

<p>Whether headed to a wedding, corporate event, or night out, this luxury limousine offers unmatched comfort and class. </p>

<p>Price: Two units are available at a price of $17,500 each, with nationwide shipping options to deliver the vehicle directly to your doorstep.</p>

            [meta_keywords] => Cadillac XTS Limousine For Sale in Las Vegas, Limousine for sale, Cadillac XTS Limousine For Sale in Las Vegas, Naveda
            [image_source] => cloud
            [user_email] => odstitleloans@gmail.com
            [slug] => 2017-cadillac-xts-limousine-2
            [userid] => 689
            [short_description] => <p>2017 Cadillac XTS 4-Door Limousine, custom-built by Royal Coach Builder for maximum style and comfort for only $17,500.</p>\r\n
            [make_name] => Cadillac
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455370/photos/nrsmdlef4brtrcp67dpx.jpg#9b26d2
            [gallery] => Array
                (
                    [12468] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455366/photos/onetqdq7udht4djwyfwt.jpg#3c80a641609d2b6627a35a27c9a91563be843669
                    [12469] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455366/photos/gzvag8bafjprpi8rpiwf.jpg#8c191b250366623607b7e83acbf236a772b27f9f
                    [12470] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455366/photos/rg13hx18nbyanlvk4e6s.jpg#a0651ac9a576c74ddb7c25a37f4316ed11b997ee
                    [12472] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455379/photos/jbq1lx82x86ubt8hbsrj.jpg#fa98d15154a26d1e2e63ea05ac8aaff3d84b2914
                    [12473] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455386/photos/chlbvfzgcl8ttn7oabeg.jpg#05d29d542d70f77540a438533b3268b4458f8f3c
                    [12474] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455394/photos/et7t9y14rige8ufmimfv.jpg#7429c9dc89bb408d1df4da1657c46e690115ae17
                    [12475] => https://res.cloudinary.com/db54ocawg/image/upload/v1767455366/photos/fruaoum8aecbfnscbgu0.jpg#b2f299
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 46343
                            [features] => Array
                                (
                                    [354] => 2017
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 46340
                            [features] => Array
                                (
                                    [545] => 6
                                )

                        )

                    [exterior-color] => Array
                        (
                            [feature_name] => Exterior Color
                            [display_type] => 3
                            [feature_id] => 17
                            [feature_values_id] => 46344
                            [features] => Array
                                (
                                    [483] => Silver/Gray
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)