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` = '1662'
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 Ford F-550 Shuttle Bus
            [id] => 1662
            [video_url] => https://youtu.be/OZRF6l9lYwY?si=CE_yhokbQ4JBwV9g
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => Tennessee
            [city] => Chattanooga
            [user_number] => 8666752271
            [meta_title] => 2017 Ford F-550 Shuttle Bus For Sale In Chattanooga, Global Limos Bus Sales
            [meta_description] => The 2017 Ford F-550 Shuttle Bus is available for sale in Chattanooga at a very reasonable price of $76,500.
            [description] => <p>Introducing the 2017 Ford F550 now available for sale!</p>

<p>This well-maintained vehicle features a pristine GM33 interior, ensuring a clean and comfortable ride for all passengers. </p>

<p>Mileage: It has a mileage of 135,302 miles, proving its reliability and performance on the road.</p>

<p>Seating Capacity: Designed to accommodate 27 passengers in the rear and 31 without luggage, this spacious vehicle is perfect for group outings or transportation services. It runs and drives exceptionally well, making it a dependable choice for any journey.</p>

<p>Located in the heart of Tennessee, we offer flexible financing options to fit your budget.</p>

<p>Asking Price: This Shuttle Bus can be yours for only $76,500.</p>

            [meta_keywords] => Ford F-550 Shuttle Bus For Sale In Chattanooga, Shuttle Bus For Sale, Ford F-550 Shuttle Bus For Sale In Chattanooga, Tennessee
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2017-ford-f-550-shuttle-bus-4
            [userid] => 291
            [short_description] => <p>2017 Ford F550 Shuttle Bus now available for sale! It has a mileage of 135,302 miles for only $76,500.</p>\r\n
            [make_name] => Ford
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569297/photos/i8ldkvwbiswolypg8ahv.jpg#a36c07
            [gallery] => Array
                (
                    [8895] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569299/photos/argsw5x6owfn3qua1vzo.jpg#d406a87091532feaf70288d8adb138dc61f7fe49
                    [8896] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569299/photos/bmz1coxtdl4ia52dkna6.jpg#111efd162b8020675e48a12aee50ef088acd9d56
                    [8897] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569299/photos/mmqn0g6jorjgmtumcemq.jpg#ebbf1b3894b1a77aab99d13c0ed2748064c43230
                    [8898] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569306/photos/gvbv04btsasjed8ssyka.jpg#484f6a49ed82a197adf0e2aabe67688df53db239
                    [8899] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569308/photos/l9ipu14fnm5ajx4hh7yd.jpg#3d3a067e0264230588bf975ad1ff6a87af963f8f
                    [8900] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569308/photos/por55nmnvgxunr7vykhq.jpg#8e1fd781fdc3a7d8bcc441de82736814993b5a29
                    [8901] => https://res.cloudinary.com/db54ocawg/image/upload/v1749569293/photos/fszbkwj5dwrneyjyyrge.jpg#c4510d
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 37119
                            [features] => Array
                                (
                                    [568] => 27
                                )

                        )

                    [exterior-color] => Array
                        (
                            [feature_name] => Exterior Color
                            [display_type] => 3
                            [feature_id] => 17
                            [feature_values_id] => 37123
                            [features] => Array
                                (
                                    [474] => Black
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [financing-available] => Array
                        (
                            [feature_name] => Financing Available
                            [display_type] => 3
                            [feature_id] => 34
                            [feature_values_id] => 37127
                            [features] => Array
                                (
                                    [550] => Yes
                                )

                        )

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

                        )

                )

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

)