Caught exception: SELECT * FROM offer o
INNER JOIN plan ON plan_id = offer_plan_id
INNER JOIN provider ON provider_id = plan_provider_id
WHERE plan_simonly = 1 AND plan_prepaid = 0 AND plan_minutes!=0 AND plan_simonly = 1 AND plan_duration = 12 AND plan_active= 1
GROUP BY plan_provider_id
ORDER BY provider_name ASC
Caught exception: SELECT * FROM plan
INNER JOIN provider ON plan_provider_id = provider_id
INNER JOIN offer ON offer_plan_id = plan_id
WHERE plan_simonly = 1 AND plan_duration = 12 AND plan_active=1
GROUP BY plan_groupname
ORDER BY plan_normal_price+plan_data_price Asc
LIMIT 80
Sim-Only
