Marketo Limitations

  1. This query applies only to List and Activity_type entities. For others, provide the filter type.
    Select * from Marketo_Table
  2. Does not support joins except between Lead and Lead_List entities. The join query between Lead and Lead_List for a List_Id is as follows:
    Select Lead.* from Lead Inner Join Lead_List
On Lead.ID = Lead_List.Lead_ID
And Lead_List.List_ID = <List ID>