SELECT 
products.id,
products.vivape_id,
products.sku,
products.routes,
products.priority_routes,
products.hold_routes,
products.cost,
products.price,
products.price_min,
products.price_max,
products.price_index,
products.price_index_min,
products.price_index_max,
products.profit_index,
products.profit_index_min,
products.profit_index_max,
products.commission_amount,
products.commission_index,
products.commission_index_min,
products.commission_index_max,
products.commission_type,
products.discount_amount,
products.discount_index,
products.discount_type,
products.discount_media,
products.discount_code,
products.starts_from,
products.ends_on,
products.inactivity_starts,
products.inactivity_ends,
products.date_of_joining,
products.user_id,
operators.name AS operator,
products.api_provider_id,
country_currencies.country_name AS country,
products.state_id,
products.city_id,
products.area_id,
products.address,
products.identity,
products.identity_type,
products.identity_attachment,
products.parent_type_id,
products.parent_category_id,
products.parent_status_id,
products.referance,
products.code,
products.title,
products.name,
products.level,
products.index,
products.index_min,
products.index_max,
products.status,
products.type,
products.category,
products.ranking,
products.priority,
products.details,
products.note,
products.description,
products.paremeters,
products.attachment,
products.image,
products.created_by,
products.updated_by,
products.created_at,
products.updated_at,
products.deleted_at
FROM products
JOIN operators ON products.operator_id = operators.id
JOIN country_currencies ON products.country_id = country_currencies.id;