SELECT `product_warehouse_link`.`warehouse_id`, `p`.`product_id`, `p`.`brand_id`, `p`.`purchase_price`, `p`.`sku`, `p`.`weight`, `c`.`carrier_id`, `c`.`carrier_name`, `c`.`carrier_display_text`, `c`.`tooltip_text`, `c`.`shipping_handling`, `c`.`free_shipping`, `c`.`range_type`, `c`.`dispatch_within`, `w`.`warehouse_name`, `pb`.`inc_tax_sell_price`, `product_warehouse_link`.`physical_quantity`, `pb`.`additional_shipping_cost`, `c`.`grade` AS `carrier_priority`, `cd`.`shipping_charges`
FROM `product_warehouse_link`
INNER JOIN `warehouse` `w` ON `product_warehouse_link`.`warehouse_id` = `w`.`warehouse_id`
INNER JOIN `warehouse_carrier_link` `wcl` ON `w`.`warehouse_id` = `wcl`.`warehouse_id`
INNER JOIN `carriers` `c` ON `wcl`.`carrier_id` = `c`.`carrier_id`
INNER JOIN `products` `p` ON `product_warehouse_link`.`product_id` = `p`.`product_id`
INNER JOIN `product_branch_1` `pb` ON `product_warehouse_link`.`product_id` = `pb`.`product_id`
INNER JOIN `carrier_branchs_link` `cbl` ON `c`.`carrier_id` = `cbl`.`carrier_id`
LEFT JOIN `carrier_zone_link` `czl` ON `c`.`carrier_id` = `czl`.`carrier_id`
LEFT JOIN `zones` `z` ON `czl`.`zone_id` = `z`.`zone_id`
LEFT JOIN `countries` `ct` ON `z`.`zone_id` = `ct`.`zone_id`
LEFT JOIN `carrier_delivery` `cd` ON `c`.`carrier_id` = `cd`.`carrier_id` AND `z`.`zone_id` = `cd`.`zone_id`
LEFT JOIN `carrier_range` `cr` ON `cd`.`range_id` = `cr`.`range_id`
WHERE `p`.`product_id` IN (363956)
AND `c`.`carrier_active` = 1
AND `product_warehouse_link`.`physical_quantity` != 0
AND `cbl`.`branch_id` = 1
AND ( (
`ct`.`country_id` = 17
AND ( (
`c`.`range_type` = 2
AND pb.inc_tax_sell_price >= cr.range_start
AND pb.inc_tax_sell_price < cr.range_end )
OR (
`c`.`range_type` = 1
AND p.weight >= cr.range_start
AND p.weight < cr.range_end ) ) )
OR (
`p`.`collection_only` = 1
AND EXISTS (SELECT 1 FROM product_carrier_links pcl WHERE pcl.product_id = p.product_id AND pcl.carrier_id = c.carrier_id) ) )
AND ( (
`p`.`product_id` IN (-1) )
OR (
`p`.`product_id` NOT IN (-1)
AND (
NOT EXISTS (SELECT 1 FROM product_carrier_links pclx WHERE pclx.product_id = p.product_id)
OR EXISTS (SELECT 1 FROM product_carrier_links pcl2 WHERE pcl2.product_id = p.product_id AND pcl2.carrier_id = c.carrier_id) ) ) )
ORDER BY `w`.`warehouse_priority` DESC, `c`.`grade` ASC<pre>123</pre>