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` = '1869'
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] => 2019 Freightliner M2 Shuttle Bus
            [id] => 1869
            [video_url] => https://youtu.be/wZbHl98fVFU?si=rpJlAzBPcqLKUaDt
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => New York
            [city] => Jamesport
            [user_number] => 8666752271
            [meta_title] => 2019 Freightliner M2 Shuttle Bus For Sale In Jamesport, Global Limos Bus Sales
            [meta_description] => The 2019 Freightliner M2 Shuttle Bus is available for sale in Jamesport at a very reasonable price of $125,900.
            [description] => <p>2019 Freightliner M2 Grech GM40, an ideal choice for those seeking a reliable vehicle for transportation services.</p>

<p>Capacity: This spacious bus comfortably accommodates 37 passengers in the rear, complete with ample luggage storage to ensure a pleasant travel experience. </p>

<p>Mileage: With 153,774 miles on the odometer, it has plenty of life left to provide dependable service.</p>

<p>Under the hood, you&#39;ll find a powerful Cummins engine paired with a smooth Allison transmission, guaranteeing both performance and efficiency. </p>

<p>This vehicle runs flawlessly and is ready to hit the road, making it an excellent opportunity to generate income.</p>

<p>Situated in New York, this bus is not only available for purchase but financing options are also offered to assist with your investment.</p>

<p>Price: The asking price for this impressive bus is $125,900. </p>

            [meta_keywords] => Freightliner M2 Shuttle Bus For Sale In Jamesport, Shuttle Bus For Sale, Freightliner M2 Shuttle Bus For Sale In Jamesport, New York
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2019-freightliner-m2-shuttle-bus-1
            [userid] => 291
            [short_description] => <p>2019 Freightliner M2 Grech GM40, an ideal choice for those seeking a reliable vehicle for transportation services with 153,774 miles for only $125,900.</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/v1756308597/photos/lq4ur8rsqpwqwqropolg.jpg#afc32d
            [gallery] => Array
                (
                    [10417] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308595/photos/nck9z5d4ov0lrlkeu79r.jpg#3bedf8b703d74ba9265cd96ab4b94e43d5668ad5
                    [10425] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308595/photos/bf6g4qxg5ibnxpitmn4m.jpg#76c596
                    [10419] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308596/photos/zbyaxixrmo7agowgw5rq.jpg#1ca4acfdcda4096758cc266bac2bc54fa44a9881
                    [10421] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308605/photos/ayf92aure7w370yfd86t.jpg#7f4c10411799c236c42208d725170e5a2cbd19c3
                    [10422] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308612/photos/fnhj9losxg1t21zkjeng.jpg#a64daa4d6c4ea54cacaf24a9b26df7789aacc936
                    [10423] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308618/photos/w4gadrd3u0timkipd8lb.jpg#692579d0639dc56054a49dc94d05cd2eba80c1b1
                    [10424] => https://res.cloudinary.com/db54ocawg/image/upload/v1756308594/photos/alab1klrmcit0pyfa9n9.jpg#eea090
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 41050
                            [features] => Array
                                (
                                    [352] => 2019
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 41047
                            [features] => Array
                                (
                                    [578] => 37
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)