SELECT DISTINCT l0_.created_at           AS created_at_0,
                l0_.updated_at           AS updated_at_1,
                l0_.id                   AS id_2,
                l0_.name                 AS name_3,
                l0_.slug                 AS slug_4,
                l0_.display_name         AS display_name_5,
                l0_.popular_category     AS popular_category_6,
                l0_.external_identifier  AS external_identifier_7,
                l0_.source_url           AS source_url_8,
                l0_.expire_date          AS expire_date_9,
                l0_.hidden               AS hidden_10,
                count(l1_.id)            AS sclr_11,
                l0_.parent_category_id   AS parent_category_id_12,
                l0_.top_most_category_id AS top_most_category_id_13,
                l0_.city_id              AS city_id_14,
                l0_.city_data_source_id  AS city_data_source_id_15,
                l0_.data_source_id       AS data_source_id_16
FROM locamo_cd_locamo_fd_product_category l0_
         INNER JOIN locamo_cd_locamo_fd_product l1_
                    ON ((l1_.category_id = l0_.id OR l1_.top_most_category_id = l0_.id) AND l1_.stock > 0 AND
                        l1_.parent_product_id IS NULL)
         LEFT JOIN locamo_cd_locamo_lift_dealer l2_ ON l1_.locamo_lift_dealer = l2_.id
         INNER JOIN locamo_city_dealer_distance l3_ ON l2_.id = l3_.dealer_id AND
                                                       (l3_.city_id = 'b3414cfc-6831-11ea-bc55-0242ac130003' AND
                                                        (l3_.in_city = 1 OR l3_.distance_in_meters < '40000'))
WHERE l0_.parent_category_id IS NULL
GROUP BY l0_.id
ORDER BY l0_.name ASC