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` = '1649'
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 Van Hool CX45 Motorcoach
            [id] => 1649
            [video_url] => https://youtu.be/2hkRc9EkH68?si=NiAmeiQas7ZoQL3R
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => New York
            [city] => Clinton
            [user_number] => 8666752271
            [meta_title] => 2017 Van Hool CX45 Motorcoach For Sale In Clinton, Global Limos Bus Sales
            [meta_description] => The 2017 Van Hool CX45 Motorcoach is available for sale in Clinton at a very reasonable price of $249,900.
            [description] => <p>Introducing the exceptional 2017 Van Hool CX45, now available for sale!</p>

<p>Capacity: This Bus can comfortably seat 56 passengers, making it ideal for group travel or charters.</p>

<p>Mileage: With 375,888 miles, this coach has proven reliability and performance on the road.</p>

<p>Powertrain: Equipped with a durable Allison transmission paired with a powerful Detroit engine, ensuring a smooth and efficient driving experience.</p>

<p>Accessibility: This unit comes with an ADA lift, catering to passengers with mobility challenges.</p>

<p>Location: Conveniently located in New York, ready for you to view and test drive.</p>

<p>Graphics: Please note that customer graphics shown in the photos will need to be removed.</p>

<p>Price: This Motorcoach can be yours for only $249,900.</p>

            [meta_keywords] => Van Hool CX45 Motorcoach for sale in Clinton, Motorcoach for sale, Van Hool CX45 Motorcoach for sale in Clinton, New York
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2017-van-hool-cx45-motorcoach
            [userid] => 291
            [short_description] => <p>2017 Van Hool CX45, now available for sale with 375,888 miles for only $249,900.</p>\r\n
            [make_name] => Van Hool
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963142/photos/euw9vvanianczkzhxkef.jpg#53693c
            [gallery] => Array
                (
                    [8795] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963122/photos/bbk7gudx4ywh3ffjyl2d.jpg#2a9813c584525299af7659adeabe3ab244ebb979
                    [8796] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963123/photos/hwv4h9fzguj5d1w0qz4g.jpg#1e8be5d25cd4725c09c50989eaa00300549ad5bb
                    [8797] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963123/photos/fyriftvtzrbiueljsee4.jpg#b2837e05e52886ddcaafec6d8fac68642247c1b0
                    [8803] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963123/photos/nmhplr9vi8txro5llgtt.jpg#f063af
                    [8799] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963135/photos/nlvo4gh8m3cwtrd5rngd.jpg#2caf66821b94d6f5cb7bf0c254eeb84c59d94803
                    [8800] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963136/photos/a7lzu5e5ki3hmursqcbz.jpg#f89454ce9591786edf4defd82378aafa877ef372
                    [8802] => https://res.cloudinary.com/db54ocawg/image/upload/v1748963122/photos/aae5o39ibafchruurztl.jpg#b6bba7
                )

            [features] => Array
                (
                    [fuel-type] => Array
                        (
                            [feature_name] => Fuel Type
                            [display_type] => 3
                            [feature_id] => 8
                            [feature_values_id] => 36945
                            [features] => Array
                                (
                                    [220] => Diesel
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 36942
                            [features] => Array
                                (
                                    [611] => 56
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)