SELECT id,
currency_id,
name,
array_to_json(client_ids) as client_ids,
availability,
margins->>'4' as margin,
delivery_times->>'4' as delivery_time,
routes->>'4' as route,
sorts->>'4' as sort,
coefficients->>'4' as coefficient,
deliveryes_percentages->>'4' as deliveryes_percentage,
type,
colors->>'4' as color,
not_have_min_prices->>'4' as not_have_min_price,
max_count_products_from_api->>'4' as max_count_products_from_api,
allow_show_products->>'4' as allow_show_products,
max_delivery_times->>'4' as max_delivery_time,
clients_texts->>'4' as clients_text,
max_count_products_from_api->>'4' as max_count_products_from_api,
clients_api_data->>'0' as main_client_api_data,
make_api_orders->>'4' as make_api_order,
groups_ids->>'4' as groups_ids,
api_stores->>'4' as api_stores,
clients_api_data->>'4' as client_api_data
FROM products.suppliers WHERE type!=1 AND 4=ANY(client_ids) AND site_statuses ->> '4' = '1' AND availability=trueint(1)
SELECT id,
currency_id,
name,
array_to_json(client_ids) as client_ids,
availability,
margins->>'4' as margin,
delivery_times->>'4' as delivery_time,
routes->>'4' as route,
sorts->>'4' as sort,
coefficients->>'4' as coefficient,
deliveryes_percentages->>'4' as deliveryes_percentage,
type,
colors->>'4' as color,
not_have_min_prices->>'4' as not_have_min_price,
max_count_products_from_api->>'4' as max_count_products_from_api,
allow_show_products->>'4' as allow_show_products,
max_delivery_times->>'4' as max_delivery_time,
clients_texts->>'4' as clients_text,
max_count_products_from_api->>'4' as max_count_products_from_api,
clients_api_data->>'0' as main_client_api_data,
make_api_orders->>'4' as make_api_order,
groups_ids->>'4' as groups_ids,
api_stores->>'4' as api_stores,
clients_api_data->>'4' as client_api_data
FROM products.suppliers WHERE type!=1 AND 4=ANY(client_ids) AND site_statuses ->> '4' = '1'int(5)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск