خطای پایگاهدادهٔ وردپرس : [Not unique table/alias: 'tb']SELECT SQL_CALC_FOUND_ROWS ne3vfr_posts.ID
FROM ne3vfr_posts JOIN ne3vfr_icl_translations wpml_translations
ON ne3vfr_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', ne3vfr_posts.post_type) INNER JOIN ne3vfr_st_activity as tb ON ne3vfr_posts.ID = tb.post_id INNER JOIN ne3vfr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN ne3vfr_st_activity as tb_st_activity ON ne3vfr_posts.ID = tb_st_activity.post_id INNER JOIN ne3vfr_st_rental as tb ON ne3vfr_posts.ID = tb.post_id
WHERE 1=1 AND ((ne3vfr_posts.post_type = 'post' AND (ne3vfr_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'fa' OR (
wpml_translations.language_code = 'fa'
AND ne3vfr_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM ne3vfr_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'fa'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ne3vfr_icl_translations t2
JOIN ne3vfr_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'fa'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND ne3vfr_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','st_hotel','hotel_room','st_activity','st_tours','st_cars','st_rental','mc4wp-form','location','st_order','st_coupon_code' ) ) OR ne3vfr_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','st_hotel','hotel_room','st_activity','st_tours','st_cars','st_rental','mc4wp-form','location','st_order','st_coupon_code' ) ) AND ne3vfr_posts.ID IN (SELECT post_id FROM ne3vfr_st_location_relationships WHERE 1=1 AND location_from IN ('15563') AND post_type IN ('st_activity')) AND ne3vfr_posts.ID IN (SELECT post_id FROM ne3vfr_st_location_relationships WHERE 1=1 AND location_from IN ('15563') AND post_type IN ('st_rental')) AND CAST(tb.rentals_booking_period AS UNSIGNED) <= 0
GROUP BY ne3vfr_posts.ID
ORDER BY tb.is_featured desc
LIMIT 0, 8
برای دریافت و مشاهده آفر قیمتی لحظه آخر ثبت نام و عضو تورلیدر شوید.
