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` = '1743'
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] => 2009 MCI D4505 Motorcoach
            [id] => 1743
            [video_url] => https://youtu.be/1h1_uSqg884?si=lq3w4JdTXihpwTVy
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => Illinois
            [city] => Chicago
            [user_number] => 8666752271
            [meta_title] => 2009 MCI D4505 Motorcoach For Sale In Chicago, Global Limos Bus Sales
            [meta_description] => The 2009 MCI J4505 is available for sale in Chicago at a very reasonable price of $59,900.
            [description] => <p>2009 MCI coach, perfect for your travel needs!</p>

<p>Capacity: This spacious coach accommodates up to 55 passengers and features a bathroom for added convenience during long trips.</p>

<p>Amenities: Enjoy entertainment on the go with six DVD monitors installed throughout the vehicle.</p>

<p>The coach comes with original, computer-documented mileage for peace of mind.</p>

<p>Recently underwent thorough servicing, which includes A/C maintenance, a new fan clutch, new belts, and a fresh preventive maintenance (PM) and Department of Transportation (DOT) inspection, ensuring it’s road-ready.</p>

<p>- This vehicle is located in Illinois, making it accessible for local buyers.</p>

<p>- Flexible financing options are available to help you make this investment.</p>

<p>Price: This vehicle is Offered at a competitive price of $59,900.</p>

            [meta_keywords] => MCI D4505 Motorcoach For Sale In Chicago, Motorcoach for sale, MCI D4505 Motorcoach For Sale In Chicago, Illinois
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2009-mci-d4505-motorcoach
            [userid] => 291
            [short_description] => <p>2009 MCI coach, perfect for your travel needs with capacity of 55 Passengers 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/v1752079188/photos/tvcsraihkspwxjyapypr.jpg#864e00
            [gallery] => Array
                (
                    [9431] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079188/photos/sw3otp4njptztmjk2z2h.jpg#4d4355cd2c17cc4fe8697803bee2cee49cbee361
                    [9432] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079188/photos/u4blowa9vi7364wa6rnx.jpg#09ce091780209eabad71d325ea272d455793dc13
                    [9433] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079188/photos/fflxot4lhz0yma80z1ax.jpg#bd978c3e5e0d46c62d955a38821032abfec9a2a7
                    [9434] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079188/photos/lvsaqozpn2bnqdpvftqg.jpg#cc612d8950a439e29d9199bee18ee0db08b84074
                    [9435] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079188/photos/q4erisu4dqilru2pdqz4.jpg#b173a61c975caf647c486d1c499d5ccfa0d75a16
                    [9436] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079189/photos/wmqfre7i8ncfmtdg2esb.jpg#c9fc75cb6be19f4b701be54195b146ab25f4290b
                    [9437] => https://res.cloudinary.com/db54ocawg/image/upload/v1752079189/photos/kxuho81cidkpewx3pzft.jpg#f149c948810b44197b7f433dac40f80685f70628
                )

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

                        )

                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 38766
                            [features] => Array
                                (
                                    [362] => 2009
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 38762
                            [features] => Array
                                (
                                    [596] => 55
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

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

)