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` = '1654'
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] => 2007 MCI D4505 Motorcoach
            [id] => 1654
            [video_url] => https://youtu.be/zkSSrcGw6LA?si=5fq-Dl0JzklJO5wV
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => South Carolina
            [city] => Charleston
            [user_number] => 8666752271
            [meta_title] => 2007 MCI D4505 Motorcoach For Sale In Charleston, Global Limos Bus Sales
            [meta_description] => The 2007 MCI D4505 Motorcoach is available for sale in Charleston at a very reasonable price of $59,900.
            [description] => <p>So here we have the 2007 MCI D4505 - A Reliable Coach Experience!</p>

<p>Capacity: This well-maintained 56 passenger southern coach is ready for its next adventure, perfect for group travels or tours.</p>

<p>Mileage:  It has a mileage of 575,589 miles, showcasing its reliability and sturdiness on the road.</p>

<p>Engine: Equipped with an Allison transmission and a powerful Detroit Series 60 engine, ensuring smooth and efficient performance.</p>

<p>Recently, the turbo was replaced, enhancing its overall functionality and driving experience.</p>

<p>Features modern amenities, including USB outlets for charging devices on the go.</p>

<p>Conveniently located in South Carolina, making it accessible for regional buyers.</p>

<p>Price: You can be the owner of this motorcoach for only $59,900. Financing options are available to help make your purchase easier.</p>

            [meta_keywords] => MCI D4505 Motorcoach For Sale In Charleston, Motorcoach for sale, MCI D4505 Motorcoach For Sale In Charleston,South Carolina
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2007-mci-d4505-motorcoach
            [userid] => 291
            [short_description] => <p>2007 MCI D4505 - A Reliable Coach Experience with 575,589 miles for only $59,900.</p>\r\n
            [make_name] => MCI
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222151/photos/niymgvao9kbqi8smq6vj.jpg#053734
            [gallery] => Array
                (
                    [8834] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222147/photos/ogsg0wb6whvsfesnmxvf.jpg#8c304840db6129915ce97f6ee80a42d2d6ad3477
                    [8835] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222147/photos/bgcnnrfh1jdkkx7jlpyn.jpg#ae2cdd028d9efa1a255f91e6b8fad3c600764704
                    [8836] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222147/photos/setf8z9ceevalqf8ygns.jpg#989c392010caea5d6f8ea38adb18e6d58798084b
                    [8837] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222148/photos/ewh3qzgcwa90b4ocuqc4.jpg#45c9cf450950922849924d845fba38259dc7ac6c
                    [8838] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222148/photos/uetfkoluppij3bdwkdje.jpg#d2dccf163b44ebac386b13028c40f290a013e6dd
                    [8839] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222148/photos/ucxgmzn5upaghhqs8cuc.jpg#6cec9efca104a85ac582a4aa2fed5d75f5e07223
                    [8841] => https://res.cloudinary.com/db54ocawg/image/upload/v1749222147/photos/rxy26btypeijqoj15rmf.jpg#34220a
                )

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

                        )

                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 37015
                            [features] => Array
                                (
                                    [364] => 2007
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [interior-color] => Array
                        (
                            [feature_name] => Interior  Color
                            [display_type] => 3
                            [feature_id] => 35
                            [feature_values_id] => 37017
                            [features] => Array
                                (
                                    [599] => Blue
                                )

                        )

                )

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

)