SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE
(
p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max
)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type='rentManual'ANDp0_.minISNULLANDp0_.maxISNOTNULLAND10<=p0_.max) OR (p0_.type='rentManual'ANDp0_.minISNOTNULLANDp0_.maxISNULLAND10>=p0_.min) OR (p0_.type='rentManual'ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND10BETWEENp0_.minANDp0_.max);
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE
(
p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max
)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type='rentManual'ANDp0_.minISNULLANDp0_.maxISNOTNULLAND21<=p0_.max) OR (p0_.type='rentManual'ANDp0_.minISNOTNULLANDp0_.maxISNULLAND21>=p0_.min) OR (p0_.type='rentManual'ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND21BETWEENp0_.minANDp0_.max);
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE
(
p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max
)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type='rentAuto'ANDp0_.minISNULLANDp0_.maxISNOTNULLAND10<=p0_.max) OR (p0_.type='rentAuto'ANDp0_.minISNOTNULLANDp0_.maxISNULLAND10>=p0_.min) OR (p0_.type='rentAuto'ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND10BETWEENp0_.minANDp0_.max);
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min) OR (p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE
(
p0_.type=?ANDp0_.minISNULLANDp0_.maxISNOTNULLAND?<=p0_.max
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNULLAND?>=p0_.min
)
OR (
p0_.type=?ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND?BETWEENp0_.minANDp0_.max
)
SELECTp0_.idASid_0,p0_.minASmin_1,p0_.maxASmax_2,p0_.amountASamount_3,p0_.typeAStype_4FROMprice_thresholdp0_WHERE (p0_.type='rentAuto'ANDp0_.minISNULLANDp0_.maxISNOTNULLAND21<=p0_.max) OR (p0_.type='rentAuto'ANDp0_.minISNOTNULLANDp0_.maxISNULLAND21>=p0_.min) OR (p0_.type='rentAuto'ANDp0_.minISNOTNULLANDp0_.maxISNOTNULLAND21BETWEENp0_.minANDp0_.max);