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` = '2177'
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] => 2018 Freightliner S2C Shuttle Bus
            [id] => 2177
            [video_url] => https://youtu.be/EjamdmRfC5Y?si=UHFM17jiNPCQQEAJ
            [username] => Jonathan Cohen
            [firstname] => Jonathan
            [lastname] => Cohen
            [email] => odstitleloans@gmail.com
            [zipcode] => 
            [country] => USA
            [state] => Nevada
            [city] => Las Vegas
            [user_number] => 8187314885
            [meta_title] => 2018 Freightliner S2C Shuttle Bus For Sale in Las Vegas, Global Limos Bus Sales
            [meta_description] => The 2018 Freightliner S2C Shuttle Bus is available for sale in Las Vegas at a very reasonable price of $53,500.
            [description] => <p>2018 Freightliner S2C Turtle Top Shuttle Bus, equipped with 25 seats including space for the driver and co-driver. </p>

<p>There are four of these premium-quality buses available, each with low mileage ranging between 55,000 and 65,000 miles, and all in like-new condition. </p>

<p>Crafted by Turtle Top, a renowned coach builder known for their durable and luxurious vehicles, these buses are reliable, efficient, and ready to serve a variety of transportation needs.</p>

<p>Powered by a robust Cummins diesel engine, these buses deliver exceptional power, dependability, and fuel efficiency.</p>

<p>They come equipped with an Allison automatic transmission, ensuring smooth gear shifts and long-lasting performance.</p>

<p>The seating layout accommodates 23 passengers comfortably, in addition to the driver and co-driver, allowing for a total capacity of 25 seats.</p>

<p>Maintained meticulously by fleet professionals, these buses are in excellent condition, presenting a clean, well-kept appearance. </p>

<p>For passenger comfort, each bus features dual Thermo King air conditioning units—one at the front and one at the rear—providing powerful cooling across the entire cabin, suitable for any weather condition.</p>

<p>These vehicles are ideal for executive shuttles, charter services, church groups, tours, or private transportation needs. </p>

<p>They are priced at $53,500 each and are ready to operate immediately, combining high-quality construction with dependable performance.</p>

            [meta_keywords] => Freightliner S2C Shuttle Bus For Sale in Las Vegas, Shuttle Bus For Sale, Freightliner S2C Shuttle Bus For Sale in Las Vegas, Naveda
            [image_source] => cloud
            [user_email] => odstitleloans@gmail.com
            [slug] => 2018-freightliner-s2c-shuttle-bus-1
            [userid] => 689
            [short_description] => <p>2018 Freightliner S2C Turtle Top Shuttle Bus, equipped with 25 seats including space for the driver and co-driver for only $53,500.</p>\r\n
            [make_name] => Freightliner
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099495/photos/ovtoxjmnt2fyhbazcwfe.jpg#593e95
            [gallery] => Array
                (
                    [12727] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099496/photos/kjcb9jhckaajawbjoyyv.jpg#0dfe4a2c901be1e740487d21375baca1fc830aef
                    [12728] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099497/photos/f9wrisykzob1ypslipbi.jpg#21366a6a78311de4135add71fad4033b348bd2a4
                    [12729] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099497/photos/dyuemzrdacwu42fhv3js.jpg#78bee6b1fddb5e8437429d3a62ceedfaff14f940
                    [12730] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099499/photos/dkher3zmx2r5y0nztmqk.jpg#89e3e8bb4d523b86a711bc0d41f74b02b7331a34
                    [12731] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099505/photos/kap7pcommomq9l44wjuy.jpg#046f48bbbdd063b2bcf0bbe9452c3d9be8b74efa
                    [12732] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099508/photos/dwsg2anqflw5igzqcz8r.jpg#3922693d85603ec96ea61ace6187c971aa4c59b1
                    [12733] => https://res.cloudinary.com/db54ocawg/image/upload/v1769099517/photos/wmurspzkf39sxjysbgnt.jpg#6952a36d31b439e4cf2b9d088918901200edfb10
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 47045
                            [features] => Array
                                (
                                    [353] => 2018
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 47042
                            [features] => Array
                                (
                                    [566] => 25
                                )

                        )

                    [exterior-color] => Array
                        (
                            [feature_name] => Exterior Color
                            [display_type] => 3
                            [feature_id] => 17
                            [feature_values_id] => 47046
                            [features] => Array
                                (
                                    [480] => White
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [interior-color] => Array
                        (
                            [feature_name] => Interior  Color
                            [display_type] => 3
                            [feature_id] => 35
                            [feature_values_id] => 47047
                            [features] => Array
                                (
                                    [607] => Silver/Gray
                                )

                        )

                )

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

)