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` = '1717'
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] => 1717
            [video_url] => 
            [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>Discover this exceptional 2017 Van Hool CX45, a remarkable opportunity for anyone in need of a reliable and spacious transportation solution! </p>

<p>One Owner & Well-Maintained: This coach has had a single owner and has been meticulously cared for, ensuring you a clean and dependable vehicle.</p>

<p>Spacious Interior: This Motorcoach Accommodates up to 56 passengers comfortably, making it ideal for group travels, tours, or charters.</p>

<p>Performance: Powered by a robust Detroit engine paired with an Allison transmission, this unit runs and drives smoothly, offering both power and efficiency on the road.</p>

<p>Mileage: With 424,000 miles, it has plenty of journeys left to offer!</p>

<p>Asking Price: This Motorcoach can be yours for only $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-1
            [userid] => 291
            [short_description] => <p>2017 Van Hool CX45, a remarkable opportunity for anyone in need of a reliable and spacious transportation solution with 424,000 miles for only $265,000. </p>\r\n\r\n<p> </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/v1751125869/photos/z3gavi0pi8xwbg0pkzoj.jpg#f84ad9
            [gallery] => Array
                (
                    [9267] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125873/photos/mueazu5emqsk06wkk7mv.jpg#db172f86a89db8b4bee0287015a99d9adecec20d
                    [9268] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125879/photos/vpbx9yjilquocfks3t8k.jpg#c4476f82ace177af0a608f82bc3030750e9f62da
                    [9269] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125878/photos/lo3zklozrskxvjvnrkpx.jpg#fca93f53507f4b01bbfb6bb61dc4b80fc7a7c9a9
                    [9270] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125879/photos/hydwveoqvbarakdfm7se.jpg#b42a6bd4c1076e36f9104b966cc5ee7fdbef774b
                    [9271] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125883/photos/tv5wmcwkvlsqaoh1unzq.jpg#ad336016dd2296f8c4b03084524111b7028bec12
                    [9272] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125884/photos/w9l2iwtzlzdyrnwy2q62.jpg#59be3cb5d5622e7875c4ad812130f5b81ea9f5fe
                    [9273] => https://res.cloudinary.com/db54ocawg/image/upload/v1751125884/photos/sxoble32vkw4gts5vqyz.jpg#832d456f851859aa6b93b52c8748c79d13c568a0
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)