SELECT *, (@rownum := @rownum + 1) AS rownum 
FROM 
(SELECT pv.*,
v1.vessel_name AS vessel_name, tb.vessel_name AS tugboat_name, cargo_zone_name, 
flot_status_name, sequence_number, dockage_name, dockage_number,
status_color_back, status_color_font, 
(IF (((fact_arrival_date = '1899-12-30') OR (fact_arrival_date IS NULL)), 
'00.00.0000', DATE_FORMAT(fact_arrival_date, '%d.%m.%Y %H:%i'))) AS fact_arrival_date_formatted, 
(IF (((dockage_setting_time = '1899-12-30') OR (dockage_setting_time IS NULL)),
'00.00.0000', DATE_FORMAT(dockage_setting_time, '%d.%m.%Y %H:%i'))) AS dockage_setting_time_formatted, 
CASE load_status WHEN 'loaded' THEN 'выгрузка' WHEN 'empty' THEN 'погрузка' WHEN 'transit' THEN 'транзит'ELSE '' END AS load_status_rus 
FROM plan_vessel pv 
INNER JOIN vessel v1 ON v1.id = pv.vessel_id
LEFT JOIN vessel tb ON tb.id = pv.tugboat_id
LEFT JOIN dockage d ON d.id = pv.dockage_id
LEFT JOIN contragent so ON so.id = v1.shipowner_id
LEFT JOIN contragent c1 ON c1.id = pv.ship_agent_id
LEFT JOIN flot_status fs ON fs.id = pv.flot_status_id
LEFT JOIN staff s ON s.id = pv.dispatcher_id
LEFT JOIN vessel_cargo_card vcc ON vcc.plan_vessel_id = pv.id 
LEFT JOIN cargo_card cc ON cc.id = vcc.id 
LEFT JOIN contract_cargo_sub ccs ON ccs.id = cc.contract_cargo_sub_id
LEFT JOIN contract_cargo_consignment ccc ON ccc.id = ccs.contract_cargo_consignment_id 
LEFT JOIN consignment cons ON cons.id = ccc.consignment_id 
LEFT JOIN contract_cargo_head cch ON cch.id = ccc.contract_cargo_head_id
LEFT JOIN contract c ON c.id = cch.contract_id 
LEFT JOIN cargo_nomenclature cn ON cn.id = cch.cargo_id 
INNER JOIN cargo_zone cz ON cz.id = pv.cargo_zone_id
WHERE fs.sequence_number >= 6
AND c.contragent_id = 922
AND fs.sequence_number < '8'
GROUP BY pv.id
ORDER BY sequence_number, fact_arrival_date DESC) AS iq
JOIN (SELECT @rownum := :this_offset) AS r
LIMIT :this_offset, :this_limit