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` = '1745'
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] => 1745
            [video_url] => https://youtu.be/ha038ILmtiI?si=qsYh5nvoYLO8kPfy
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => Florida
            [city] => Orlando
            [user_number] => 8666752271
            [meta_title] => 2017 Van Hool CX45 Motorcoach For Sale In Orlando, Global Limos Bus Sales
            [meta_description] => The 2017 Van Hool CX45 Motorcoach is available for sale in Orlando at a very reasonable price of $265,000.
            [description] => <p>Introducing the 2017 Van Hool CX45 for sale.</p>

<p>Capacity: This well-maintained coach is a clean, one-owner vehicle that comfortably seats 56 passengers and has primarily operated in the southern region. </p>

<p>Mileage: It has an impressive mileage of 424,000 miles and is equipped with an Allison transmission paired with a powerful Detroit engine, ensuring a smooth and reliable driving experience.</p>

<p>Located in sunny Florida, this coach is perfect for anyone looking to upgrade their fleet or start a new venture. Plus, financing options are available to make your purchase easier!</p>

<p>Price: The asking price is $265,000.</p>

            [meta_keywords] => Van Hool CX45 Motorcoach For Sale In Orlando, Motorcoach for sale, Van Hool CX45 Motorcoach For Sale In Orlando, Florida
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2017-van-hool-cx45-motorcoach-2
            [userid] => 291
            [short_description] => <p>2017 Van Hool CX45 Motorcoach for sale with 424,000 miles for only $265,000.</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/v1752131739/photos/olocjptvglc3vmnpjul2.jpg#6d55f5
            [gallery] => Array
                (
                    [9446] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131739/photos/rwkdva0uv77kouhzz8lq.jpg#a213242780b873611f6a7247dbfa084afeab0c43
                    [9447] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131740/photos/zozr6aoj8abyuwheqtuh.jpg#bd729e5c171f3ebee0084cd9e416de2796621780
                    [9454] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131739/photos/bg4mrdzmuydhg0esimqa.jpg#edfd21
                    [9449] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131740/photos/uwjfkbvoic6w1jxyv8eh.jpg#8fe4f54c333ade2516d527287aa05049dbfce9ac
                    [9450] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131740/photos/kcqwaplcimdfgqt7rkxi.jpg#726839ce6888077e534fec2409977d695e74c67f
                    [9451] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131740/photos/rniltxq6mbimt0zpwclk.jpg#d8e3c04eeab12a72223136dc87e25aea3bd5f7b0
                    [9452] => https://res.cloudinary.com/db54ocawg/image/upload/v1752131740/photos/dwa3jp8vxulycwzdbo09.jpg#269fbc4382b2adae61598ad88ac38fae70b06f30
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)