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` = '1779'
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] => 2013 Mercedes Benz Sprinter
            [id] => 1779
            [video_url] => https://youtu.be/RGUsHEW_vdE?si=iBNayqizsH-MokRn
            [username] => Rohonde Moore
            [firstname] => Rohonde
            [lastname] => Moore
            [email] => info@bamalimousine.com
            [zipcode] => 
            [country] => USA
            [state] => Ramey
            [city] => New Market
            [user_number] => 2565131473
            [meta_title] => 2013 Mercedes Benz Sprinter For Sale In New Market, Global Limos Bus Sales
            [meta_description] => The 2013 Mercedes Benz Sprinter is available for sale in New Market at a very reasonable price of $59,950.
            [description] => <p>2013 Mercedes-Benz Sprinter 2500 Passenger, the ultimate vehicle for luxury transport.</p>

<p>Mileage: This stunning truck has only been driven 43,000 miles and is ready to impress.</p>

<p>Imagine cruising in style with all the amenities you could desire. This Sprinter has been expertly transformed into a lavish limo, featuring not one, but two cooling units to keep your drinks perfectly chilled.</p>

<p>Enjoy your favorite shows on not one, but two high-definition televisions, while relaxing in plush captain&#39;s chairs surrounded by vibrant, new neon lighting that sets the perfect mood.</p>

<p>The interior boasts elegant fabric blinds and a well-designed partition for privacy, ensuring a relaxing atmosphere for passengers.</p>

<p>The back area includes a convenient toilet space, discreetly enclosed with a black box for maximum privacy.</p>

<p>A spacious cargo area adds practicality to this luxury ride, making it perfect for any occasion.</p>

<p>This vehicle runs and drives like a dream, with a powerful engine and ice-cold air conditioning to keep everyone comfortable, no matter the weather. </p>

<p>We currently rent it out for $175 an hour with a four-hour minimum, but with plans to upgrade our fleet, we are open to trading for a newer model stretch limousine. </p>

<p>Price: This Sprinter can be yours for only $59,950.</p>

            [meta_keywords] => Mercedes Benz Sprinter For Sale In New Market, Sprinter for sale, Mercedes Benz Sprinter for sale in New Market, Albama
            [image_source] => cloud
            [user_email] => info@bamalimousine.com
            [slug] => 2013-mercedes-benz-sprinter-7
            [userid] => 1138
            [short_description] => <p>2013 Mercedes-Benz Sprinter 2500 Passenger, the ultimate vehicle for luxury transport with 43,000 miles for only $59,950.</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/v1753114587/photos/yg8fzsc9ip2i0gouup7q.jpg#54a5ae
            [gallery] => Array
                (
                    [9710] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114592/photos/x8tbzgaq2chgaryuqxes.jpg#d931f445f53ca9ad3e9a8768090132032e372d66
                    [9711] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114600/photos/qtqrh2qmhhiiwofikr8z.jpg#ad1fc47457490ec9981a46a3b202ffc950d5efaa
                    [9712] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114601/photos/awqvpddp6tgup96tms5a.jpg#564a69e54cb6b3ef0636950bcdde32ef899e6eed
                    [9713] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114605/photos/ltojyuakl2qvhbzhn4nl.jpg#252dc537ac49d0be440b25b8b43d423c3fcbcb23
                    [9714] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114606/photos/ghtgxjodkewinnmlrxdi.jpg#82085a67b6c01b9e94cabe361348d93d16244925
                    [9715] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114609/photos/nlzl9v2ryguwpl6w57zc.jpg#cf6584eb915d2683b646a3572c7034d849203616
                    [9716] => https://res.cloudinary.com/db54ocawg/image/upload/v1753114610/photos/emuxcufvecyvvjiclrcc.jpg#3a5a09bfcef0b9f0bffce5ff02dd8f34f2564fad
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 39574
                            [features] => Array
                                (
                                    [358] => 2013
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 39571
                            [features] => Array
                                (
                                    [555] => 14
                                )

                        )

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

                        )

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

                        )

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

                        )

                    [mechanical-condition-rating] => Array
                        (
                            [feature_name] => Mechanical Rating
                            [display_type] => 3
                            [feature_id] => 31
                            [feature_values_id] => 39581
                            [features] => Array
                                (
                                    [519] => 10
                                )

                        )

                    [exterior-condition-rating] => Array
                        (
                            [feature_name] => Exterior Rating
                            [display_type] => 3
                            [feature_id] => 32
                            [feature_values_id] => 39582
                            [features] => Array
                                (
                                    [529] => 10
                                )

                        )

                    [interior-condition-rating] => Array
                        (
                            [feature_name] => Interior Rating
                            [display_type] => 3
                            [feature_id] => 33
                            [feature_values_id] => 39583
                            [features] => Array
                                (
                                    [539] => 10
                                )

                        )

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

                        )

                )

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

)