Fetch Incomplete Bajaj Order between a time period

SELECT fk_orders.order_id AS "ORDER ID",
CONCAT(firstname," ",lastname) AS "CUSTOMER NAME", RIGHT(fk_orders.phone, 10) AS "CUSTOMER PHONE", email AS "EMAIL",
CONCAT(s_firstname," ",s_lastname) AS "SHIPPING NAME", RIGHT(fk_orders.s_phone, 10) AS "SHIPPING PHONE",
s_address AS "SHIPPING ADDRESS 1",s_address_2 AS "SHIPPING ADDRESS 2",s_city AS "SHIPPING CITY",s_zipcode AS "SHIPPING PINCODE",
GROUP_CONCAT(fk_order_details.product_code) AS "SKU",
GROUP_CONCAT(fk_product_descriptions.product) AS "PRODUCT NAMES",
fk_orders.total AS "TOTAL PRICE",
DATE_FORMAT(convert_tz(FROM_UNIXTIME(timestamp),'+00:00','+05:30'), '%h:%i %p, %d %M %Y') AS "DATE"
FROM fk_orders
INNER JOIN fk_order_details ON fk_order_details.order_id = fk_orders.order_id
INNER JOIN fk_product_descriptions ON fk_product_descriptions.product_id = fk_order_details.product_id
WHERE fk_orders.payment_id IN (22) AND fk_orders.timestamp >= 1682879400 AND fk_orders.timestamp <= 1696444199 AND fk_orders.status = 'N'
GROUP BY fk_orders.order_id
ORDER BY timestamp ASC