SELECT barcode_info.id, barcode_info.barcode, barcode_info.quantity_active, barcode_info.quantity_pending, barcode_info.warehouse_id, barcode_info.sku_id, barcode_info.quantity_movement, sku.id AS id_1, sku.adult, sku.content_hidden, sku.identifier_required, sku.product_group, sku.returnable, sku.sku_id AS sku_id_1, sku.title, sku.quantity_reserved_awaiting_lp_answer, sku.has_datamatrix, sku.was_weighted, sku.has_shelf_life, sku.has_serial, sku.has_imei, sku.description, sku.height, sku.length, sku.width, sku.full_name, sku.image_url, sku.product_id, sku.shop_id, sku.volume, sku.weight 
FROM barcode_info JOIN sku ON sku.sku_id = barcode_info.sku_id 
WHERE barcode_info.barcode = '120405907894' AND barcode_info.warehouse_id = 1693627