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` = '1705'
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] => 2013 Freightliner CT Coach Limo Bus
            [id] => 1705
            [video_url] => https://youtu.be/RouqTlGKic0?si=CwejtS9tXi0QTGdO
            [username] => Eric Coolbaugh
            [firstname] => Eric
            [lastname] => Coolbaugh
            [email] => mert@advantageremarketing.com
            [zipcode] => 21122
            [country] => USA
            [state] => Maryland
            [city] => Pasadena
            [user_number] => 8666752271
            [meta_title] => 2013 Freightliner CT Coach Limo Bus For Sale In Pasadena, Global Limos Bus Sales
            [meta_description] => The 2013 Freightliner Coach Limo Bus is available for sale in Pasadena at a very reasonable price of $59,900.
            [description] => <p>2013 Freightliner CT Customs limo bus, perfect for those looking to transport a larger group in style and comfort! </p>

<p>Mileage: With only 85,180 miles, ensuring plenty of life left in this reliable vehicle.</p>

<p>Transmission: Equipped with a smooth Allison transmission for an effortless driving experience.</p>

<p>Engine: Powered by a robust Cummins engine, known for its durability and performance.</p>

<p>Location: Conveniently located in Pasadena, MD, making it easy for local buyers to take a look.</p>

<p>Financing Options: Available to help you get on the road with flexible payment plans.</p>

<p>Price: You can get this Limo Bus for only $59,900.</p>

            [meta_keywords] => Freightliner Coach Limo Bus For Sale, Limo Bus for sale, Freightliner CT Limo Bus for sale in Pasadena, Maryland
            [image_source] => cloud
            [user_email] => mert@advantageremarketing.com
            [slug] => 2013-freightliner-ct-coach-limo-bus
            [userid] => 291
            [short_description] => <p>2013 Freightliner CT Customs limo bus, perfect for those looking to transport a larger group in style and comfort with 85,180 miles for only $59,900.</p>\r\n\r\n<p> </p>\r\n
            [make_name] => Freightliner
            [phone_code_id] => 1
            [phonecode] => +1
            [is_deleted] => 0
            [expired] => 0
            [primary_img] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778918/photos/xoll1uay2xxdgvt6qdtu.jpg#1ca9e9
            [gallery] => Array
                (
                    [9174] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778918/photos/kpgzl7svzh1iqnniv2jm.jpg#1ea45267db75ef9a37bd354e7bf98022a3e80b3a
                    [9176] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778919/photos/ljxpfgqukdzex38rfdmh.jpg#e62164f3f6f1c7b6771ac26ff6a96a4a320421d4
                    [9177] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778920/photos/nhrgo649argj6fmqavzf.jpg#28249a00c52ce8c7ad2baf8704cc29b329b33e38
                    [9178] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778920/photos/mm2gxyzc5vcwdez9ba8e.jpg#2ab1b9cba74b78b714144ae923e7fe27231005d5
                    [9179] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778923/photos/woe27mtya7mrbfzqjy7k.jpg#6d263f59e6cf5077011327bb61e74cdcec97f40f
                    [9180] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778924/photos/r3hwhlyawjmulkpowlg1.jpg#458d7628ca70575bacc76686e6544f982b3b1bbc
                    [9181] => https://res.cloudinary.com/db54ocawg/image/upload/v1750778917/photos/bnvzj1dmvp9ll7dws4jp.jpg#4e998b
                )

            [features] => Array
                (
                    [year-coach-built] => Array
                        (
                            [feature_name] => Year Coach Built
                            [display_type] => 3
                            [feature_id] => 10
                            [feature_values_id] => 38007
                            [features] => Array
                                (
                                    [358] => 2013
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [customer-capacity] => Array
                        (
                            [feature_name] => Capacity
                            [display_type] => 3
                            [feature_id] => 16
                            [feature_values_id] => 38004
                            [features] => Array
                                (
                                    [576] => 35
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [exterior-condition-rating] => Array
                        (
                            [feature_name] => Exterior Rating
                            [display_type] => 3
                            [feature_id] => 32
                            [feature_values_id] => 38016
                            [features] => Array
                                (
                                    [528] => 9
                                )

                        )

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

                        )

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

                        )

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

                        )

                )

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

)