| | |
|---|
| | | SELECT p.* FROM`yeshi_ec_special` p
|
|---|
| | | LEFT JOIN `yeshi_ec_special_card` c ON p.`b_card_id` = c.`cd_id`
|
|---|
| | | WHERE p.`b_state` = 0 AND c.`cd_state` = 0 AND c.`cd_card` = #{card}
|
|---|
| | | AND IF(p.`b_min_android_version_code` IS NOT NULL, IF(#{minIOSVersionCode} <![CDATA[>=]]> p.`b_min_ios_version_code` AND p.`b_min_android_version_code`=#{minAndroidVersionCode}, TRUE,FALSE), TRUE)
|
|---|
| | | <if test="platform == 1">
|
|---|
| | | AND IF(p.`b_min_android_version_code` IS NOT NULL, #{versionCode}<![CDATA[>=]]> p.b_min_android_version_code,TRUE)
|
|---|
| | | </if>
|
|---|
| | | <if test="platform == 2">
|
|---|
| | | AND IF(p.`b_min_ios_version_code` IS NOT NULL, #{versionCode}<![CDATA[>=]]> p.b_min_ios_version_code,TRUE)
|
|---|
| | | </if>
|
|---|
| | | ORDER BY p.`b_orderby`
|
|---|
| | | LIMIT ${start},${count}
|
|---|
| | | </select>
|
|---|
