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` = '1944'
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] => 2011 Freightliner M2 Shuttle Bus
            [id] => 1944
            [video_url] => https://youtu.be/LpwwBI5C3_U?si=OuFXnNZKhhJdgtXl
            [username] => Ryan OSteen
            [firstname] => Ryan
            [lastname] => OSteen
            [email] => info@nationsbus.com
            [zipcode] => 
            [country] => USA
            [state] => Florida
            [city] => St. Augustine
            [user_number] => 8005233262
            [meta_title] => 2011 Freightliner M2 Shuttle Bus For Sale In St Augustine, Global Limos Bus Sales
            [meta_description] => The 2011 Freightliner M2 Shuttle Bus is available for sale in St Augustine at a very reasonable price of $32,800.
            [description] => <p>The Freightliner M2 Shuttle Bus is a spacious and well-equipped vehicle, designed to accommodate up to 29 passengers comfortably. </p>

<p>Mileage: It features a powerful 6.7L V6 Cummins ISB engine paired with an automatic transmission, and has an odometer reading of 144,835 miles. The bus is powered by diesel fuel and is painted in a clean white color.</p>

<p>Inside, passengers can enjoy high-back reclining seats that are covered in upgraded blue vinyl, with upholstered armrests and retractable seat belts for added comfort and safety. </p>

<p>Interior: The interior is finished with gray vinyl walls and a ceiling that is enhanced by interior overhead dome lighting. An upgraded 8-speaker sound system and passenger window blinds ensure a pleasant travel experience.</p>

<p>Practical features include a rear luggage compartment, an umbrella storage box, and two double rear flip seats for additional flexibility. </p>

<p>The bus is equipped with a Braun Century wheelchair lift and includes two Q’Straint tie downs, making it accessible for all passengers. </p>

<p>Price: This shuttle bus is available for a price of $32,800.</p>

            [meta_keywords] => Freightliner M2 Shuttle Bus For Sale in St. Augustine, Shuttle Bus For Sale, Freightliner M2 Shuttle Bus For Sale In St Augustine, Florida
            [image_source] => cloud
            [user_email] => info@nationsbus.com
            [slug] => 2011-freightliner-m2-shuttle-bus-1
            [userid] => 1204
            [short_description] => <p>2011 Freightliner M2 Shuttle Bus is a spacious and well-equipped vehicle, designed to accommodate up to 29 passengers comfortably for only $32,800.</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/v1758708486/photos/wiwxhhgj40ugquzgmscz.jpg#1f3e9d
            [gallery] => Array
                (
                    [10963] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708469/photos/surxeuyse4c5sx7f03pt.jpg#cd7513e062da59196daae70b66d222dfe80573e0
                    [10964] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708478/photos/qihgkhifjqjayzybqqgb.jpg#890c780c6b03273589696a3e886f2596651e297c
                    [10966] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708494/photos/w9bwr955v7cjiqug0yr4.jpg#3ef6a7f85c0afb5fbac32e6ab7b3ff3e5bfafc07
                    [10967] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708502/photos/zc3llrjtyrgn9dso69kg.jpg#6b94f19979913d75d68eacdf6c0c296ef06557dc
                    [10968] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708510/photos/qffkjyp9nd32z4xxpqib.jpg#e1769da13c6fde38570d09e6965e08cb85275306
                    [10969] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708518/photos/yvklclvibzzjizhnsbbn.jpg#8e29aa3a15061af688bbc3755c4c12c05ba2ee6c
                    [10970] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708519/photos/ukfcup7uvangifjxhrhr.jpg#8b205085d1e173098e1cd84cfed7d0e30c1983a9
                    [10971] => https://res.cloudinary.com/db54ocawg/image/upload/v1758708466/photos/rdbrv7x2hx6xh3np0zuj.jpg#11d018
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 42717
                            [features] => Array
                                (
                                    [360] => 2011
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 42714
                            [features] => Array
                                (
                                    [570] => 29
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)